DBA Data[Home] [Help]

APPS.AP_ACCTG_PREPAY_DIST_PKG dependencies on AP_INVOICE_LINES

Line 251: FROM AP_Invoice_Lines_ALL AIL,

247: AIL.Org_ID,
248: AID.Accounting_Date,
249: -- 6718967
250: DECODE(NVL(AID.Parent_Reversal_ID,-99), -99, 1, 2) Group_Number
251: FROM AP_Invoice_Lines_ALL AIL,
252: AP_Invoice_Distributions_All AID
253: WHERE AIL.Invoice_ID = p_invoice_id
254: AND AIL.Line_Type_Lookup_Code = 'PREPAY'
255: AND AIL.Invoice_ID = AID.Invoice_ID

Line 275: FROM AP_Invoice_Lines AIL,

271: AIL1.Org_ID,
272: AID.Accounting_Date,
273: -- 6718967
274: DECODE(NVL(AID.Parent_Reversal_ID,-99), -99, 1, 2) Group_Number
275: FROM AP_Invoice_Lines AIL,
276: AP_Invoice_Distributions AID,
277: AP_Invoice_Lines AIL1,
278: AP_Invoice_Distributions AID1
279: WHERE AID.Invoice_ID = p_invoice_id

Line 277: AP_Invoice_Lines AIL1,

273: -- 6718967
274: DECODE(NVL(AID.Parent_Reversal_ID,-99), -99, 1, 2) Group_Number
275: FROM AP_Invoice_Lines AIL,
276: AP_Invoice_Distributions AID,
277: AP_Invoice_Lines AIL1,
278: AP_Invoice_Distributions AID1
279: WHERE AID.Invoice_ID = p_invoice_id
280: AND AID.Line_Type_Lookup_Code = 'PREPAY'
281: AND AID.Invoice_ID = AIL.Invoice_ID