DBA Data[Home] [Help]

APPS.AP_ACCTG_PAY_DIST_PKG dependencies on AP_INVOICES_ALL

Line 880: AP_Invoices_All AI,

876: INTO G_Last_NonExcluded_Dist_ID
877: FROM (SELECT AID.Invoice_Distribution_ID
878: FROM AP_Invoice_Distributions_All AID,
879: Financials_System_Params_All FSP,
880: AP_Invoices_All AI,
881: AP_System_Parameters_All ASP
882: WHERE AID.Invoice_ID = l_inv_rec.Invoice_ID
883: AND AI.Invoice_ID = AID.Invoice_ID
884: AND ASP.Org_ID = AI.Org_ID

Line 5675: AP_Invoices_All AI,

5671: AP_Payment_History_All APH,
5672: XLA_AE_Headers AEH,
5673: XLA_AE_Lines AEL,
5674: AP_Inv_Dists_Source AID1,
5675: AP_Invoices_All AI,
5676: AP_Invoice_Distributions_All AID,
5677: AP_Payment_Hist_Dists APHD,
5678: XLA_Transaction_Entities_Upg XTE_INV --Bug7169843 Bug11071399
5679: WHERE AC.Check_ID = p_xla_event_rec.source_id_int_1

Line 5794: AP_Invoices_All AI,

5790: XLA_AE_Headers AEH,
5791: XLA_AE_Lines AEL,
5792: AP_Payment_Hist_Dists APHD,
5793: AP_Invoice_Distributions_All AID,
5794: AP_Invoices_All AI,
5795: XLA_Transaction_Entities_Upg XTE_INV --Bug7169843 Bug11071399
5796: WHERE AC.Check_ID = p_xla_event_rec.source_id_int_1
5797: AND AC.Org_ID = ASP.Org_ID
5798: AND XLE.Event_ID = p_accounting_event_id

Line 6108: AP_Invoices_All AI,

6104: AP_Payment_History_All APH,
6105: XLA_AE_Headers AEH,
6106: XLA_AE_Lines AEL,
6107: AP_Inv_Dists_Source AID1,
6108: AP_Invoices_All AI,
6109: AP_Invoice_Distributions_All AID,
6110: AP_Payment_Hist_Dists APHD,
6111: XLA_Transaction_Entities_Upg XTE_INV, --Bug7169843 Bug11071399
6112: AP_MC_Invoice_Dists AID_MC

Line 6207: AP_Invoices_All AI,

6203: XLA_AE_Headers AEH,
6204: XLA_AE_Lines AEL,
6205: AP_Payment_Hist_Dists APHD,
6206: ap_mc_invoice_dists AID_MC,
6207: AP_Invoices_All AI,
6208: XLA_Transaction_Entities_Upg XTE_INV, --Bug7169843 Bug11071399
6209: AP_Invoice_Distributions_All AID,
6210: AP_Inv_Dists_Source AID1 --13520870
6211: WHERE AC.Check_ID = p_xla_event_rec.source_id_int_1