Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Oracle Financials: Find Approved Invoices in AP Module

Oracle Financials: Find Approved Invoices in AP Module

From: IrelandA <IrelandA_at_Syntegra.Bt.Co.Uk>
Date: Thu, 26 Aug 1999 11:28:23 +0100
Message-ID: <7q34tl$sva$1@pheidippides.axion.bt.co.uk> 





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 - 05:28:23 CDT












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US