Re: Oracle Financials: Find Approved Invoices in AP Module

Hey Al,

     This one is a bit tricky. I assume that Oracle Apps used to store the value in the APPROVAL_STATUS column, but it now just for reference purposes. Try this one:

select invoice_id
  from ap_invoices ai
 where AP_INVOICES_PKG.GET_APPROVAL_STATUS(

          AI.INVOICE_ID,
          AI.INVOICE_AMOUNT,
          AI.PAYMENT_STATUS_FLAG,
          AI.INVOICE_TYPE_LOOKUP_CODE) = 'APPROVED'

     You can also try using the AP_INVOICES_DERIVED_V view, but I wouldn't assume that it is going to stay the same between releases. For 10.7 the query would be:

select invoice_id
  from ap_invoices_derived_v
 where APPROVAL_STATUS_LOOKUP_CODE = 'APPROVED' /

Jay!!!

IrelandA wrote:

> Dear All
>
> I'm not sure if this is the right Newsgroup to post this query to. Please
> advise if not.
>
> I am trying to write a SQL script to extract APPROVED invoices only from the
> Accounts Payable module of Oracle Financials.
>
> Can anyone advise how I can do this. Obviously I have looked at the fields
> APPROVAL_STATUS and APPROVAL_DESCRIPTION in the table AP_INVOICES, but
> unfortunately these fields are blank.
>
> Any help would be gratefully received.
>
> Thanks
>
> Al
Received on Thu Aug 26 1999 - 17:07:40 CDT