DBA Data[Home] [Help]

APPS.AP_ACCTG_PREPAY_DIST_PKG dependencies on AP_INVOICE_LINES

Line 122: FROM AP_Invoice_Lines_ALL AIL,

118: AIL.Org_ID,
119: AID.Accounting_Date,
120: -- 6718967
121: DECODE(NVL(AID.Parent_Reversal_ID,-99), -99, 1, 2) Group_Number
122: FROM AP_Invoice_Lines_ALL AIL,
123: AP_Invoice_Distributions_All AID
124: WHERE AIL.Invoice_ID = p_invoice_id
125: AND AIL.Line_Type_Lookup_Code = 'PREPAY'
126: AND AIL.Invoice_ID = AID.Invoice_ID

Line 142: FROM AP_Invoice_Lines AIL,

138: AIL1.Org_ID,
139: AID.Accounting_Date,
140: -- 6718967
141: DECODE(NVL(AID.Parent_Reversal_ID,-99), -99, 1, 2) Group_Number
142: FROM AP_Invoice_Lines AIL,
143: AP_Invoice_Distributions AID,
144: AP_Invoice_Lines AIL1,
145: AP_Invoice_Distributions AID1
146: WHERE AID.Invoice_ID = p_invoice_id

Line 144: AP_Invoice_Lines AIL1,

140: -- 6718967
141: DECODE(NVL(AID.Parent_Reversal_ID,-99), -99, 1, 2) Group_Number
142: FROM AP_Invoice_Lines AIL,
143: AP_Invoice_Distributions AID,
144: AP_Invoice_Lines AIL1,
145: AP_Invoice_Distributions AID1
146: WHERE AID.Invoice_ID = p_invoice_id
147: AND AID.Line_Type_Lookup_Code = 'PREPAY'
148: AND AID.Invoice_ID = AIL.Invoice_ID