DBA Data[Home] [Help]

APPS.AP_XLA_UPGRADE_PKG dependencies on AP_PAYMENT_HISTORY_ALL

Line 1185: AP_Payment_History_All APH,

1181: XLA_Transaction_Entities_Upg XTE,
1182: XLA_Events XLE,
1183: AP_Invoice_Payments_All AIP,
1184: AP_Invoices_All AI,
1185: AP_Payment_History_All APH,
1186: XLA_AE_Headers AEH,
1187: XLA_AE_Lines AEL,
1188: AP_Invoice_Distributions_All AID_a
1189: WHERE AC.rowid BETWEEN p_start_rowid AND p_end_rowid

Line 1579: AP_Payment_History_All APH,

1575: AP_System_Parameters_All ASP,
1576: XLA_Upgrade_Dates UPG,
1577: XLA_Transaction_Entities_Upg XTE,
1578: XLA_Events XLE,
1579: AP_Payment_History_All APH,
1580: XLA_AE_Headers AEH,
1581: XLA_AE_Lines AEL,
1582: AP_Invoice_Distributions_All AID,
1583: AP_Payment_Hist_Dists APHD,

Line 1854: AP_Payment_History_All APH,

1850: AP_System_Parameters_All ASP,
1851: XLA_Upgrade_Dates UPG,
1852: XLA_Transaction_Entities_Upg XTE,
1853: XLA_Events XLE,
1854: AP_Payment_History_All APH,
1855: XLA_AE_Headers AEH,
1856: XLA_AE_Lines AEL,
1857: AP_Payment_Hist_Dists APHD,
1858: AP_Invoice_Distributions_All AID,

Line 2107: FROM AP_Payment_History_All APH,

2103: AND ASP.Set_Of_Books_ID = p_ledger_id
2104: AND ASP.Set_Of_Books_ID = UPG.Ledger_ID
2105: AND ASP.Future_Dated_Pmt_Liab_Relief = 'MATURITY'
2106: AND NOT EXISTS (SELECT 'Payment Maturity'
2107: FROM AP_Payment_History_All APH,
2108: XLA_Events XLE,
2109: XLA_AE_Headers XEH1
2110: WHERE APH.Accounting_Event_ID = XLE.Event_ID
2111: AND XLE.Event_ID = XEH1.Event_ID