DBA Data[Home] [Help]

APPS.PJM_TRANSFER_IPV_PKG dependencies on AP_INVOICES

Line 234: AP_Invoices INV,

230: , POD.PO_Distribution_Id PO_Distribution_Id
231: , POD.Destination_Type_Code Destination_Type_Code
232: , DIST.RCV_Transaction_Id RCV_Transaction_Id
233: FROM
234: AP_Invoices INV,
235: AP_Invoice_Distributions DIST,
236: PO_Distributions POD,
237: PO_Lines POL,
238: PA_Projects_ALL PAP,

Line 347: -- from ap_invoices inv

343: -- , 'J' , 'K' , 'M' , 'P' , 'Q' , 'V' , 'X' , 'W' )
344: -- AND DIST.Line_Type_Lookup_Code = 'ITEM'
345: -- AND exists (
346: -- select 'X'
347: -- from ap_invoices inv
348: -- where inv.invoice_id = dist.invoice_id
349: -- and inv.invoice_type_lookup_code <> 'EXPENSE REPORT')
350: -- AND DIST.Accounting_Date <=
351: -- NVL(l_Trx_Thru_Date, DIST.Accounting_Date)