APPS.AP_XLA_UPGRADE_PKG dependencies on AP_INVOICES_ALL

Line 249: FROM AP_Invoices_All AI,

245: AID.Invoice_Line_Number,
246: AID.Distribution_Line_Number,
247: FC.Minimum_Accountable_Unit Min_Acct_Unit,
248: FC.Precision Precision
249: FROM AP_Invoices_All AI,
250: XLA_Upgrade_Dates UPG,
251: AP_Accounting_Events_All AAE,
252: XLA_AE_Headers AEH,
253: XLA_AE_Lines AEL,

Line 301: FROM AP_Invoices_All AI,

297: AID.Invoice_Line_Number,
298: AID.Distribution_Line_Number,
299: FC.Minimum_Accountable_Unit Min_Acct_Unit,
300: FC.Precision Precision
301: FROM AP_Invoices_All AI,
302: XLA_Upgrade_Dates UPG,
303: AP_Accounting_Events_All AAE,
304: XLA_AE_Headers AEH,
305: XLA_AE_Lines AEL,

Line 361: FROM AP_Invoices_All AI,

357: AID.Invoice_Line_Number,
358: AID.Distribution_Line_Number,
359: FC.Minimum_Accountable_Unit Min_Acct_Unit,
360: FC.Precision Precision
361: FROM AP_Invoices_All AI,
362: XLA_Upgrade_Dates UPG,
363: AP_Accounting_Events_All AAE,
364: XLA_AE_Headers AEH,
365: XLA_AE_Lines AEL,

Line 494: FROM AP_Invoices_All AI,

490: AID.Invoice_Line_Number,
491: AID.Accounting_Date,
492: Row_Number() OVER (PARTITION BY AID.Accounting_Event_ID, AID.Invoice_ID
493: ORDER BY Invoice_Line_Number) RNum
494: FROM AP_Invoices_All AI,
495: XLA_Upgrade_Dates UPG,
496: AP_Invoice_Distributions_All AID
497: WHERE AI.Invoice_ID BETWEEN p_start_id and p_end_id
498: AND TRUNC(AI.GL_Date) BETWEEN UPG.Start_Date and UPG.End_Date

Line 607: FROM AP_Invoices_All AI,

603: NVL(AI.Base_Amount, AI.Invoice_Amount))) Accounted_Amt,
604: (NVL(AEL.Entered_Cr, 0) - NVL(AEL.Entered_Dr, 0)) * AID.Amount /
605: NVL2(AEL.Account_Overlay_Source_ID, DECODE(AID1.Amount,0,1,AID1.Amount),
606: DECODE(AI.Invoice_Amount,0,1,AI.Invoice_Amount)) Entered_Amt
607: FROM AP_Invoices_All AI,
608: XLA_Upgrade_Dates UPG,
609: AP_System_Parameters_All ASP,
610: AP_Accounting_Events_All AAE,
611: AP_Prepay_History_All APH,

Line 720: FROM AP_Invoices_All AI,

716: 'S' Line_Definition_Owner_Code,
717: 'ACCRUAL_INVOICES_ALL' Line_Definition_Code,
718: 'INVOICES' Event_Class_Code,
719: 'INVOICES_ALL' Event_Type_Code
720: FROM AP_Invoices_All AI,
721: XLA_Upgrade_Dates UPG,
722: AP_Accounting_Events_All AAE,
723: AP_Prepay_App_Dists APAD,
724: AP_Invoice_Distributions_All AID,

Line 922: AP_Invoices_All AI,

918: AP_Payment_History_All APH,
919: XLA_AE_Headers AEH,
920: XLA_AE_Lines AEL,
921: AP_Invoice_Distributions_All AID,
922: AP_Invoices_All AI,
923: AP_Inv_Dists_Source AID1,
924: FND_Currencies FC
925: WHERE AC.Check_ID BETWEEN p_start_id AND p_end_id
926: AND TRUNC(AC.Check_Date) BETWEEN UPG.Start_Date and UPG.End_Date

Line 1405: l_table_name := 'AP_INVOICES_ALL';

1401: 'Worker: '||P_Worker_Id||' P_Num_Workers is ' || P_Num_Workers );
1402: END IF;
1403:
1404:
1405: l_table_name := 'AP_INVOICES_ALL';
1406: l_script_name := p_inv_script_name;
1407: l_id_column := 'INVOICE_ID';
1408:
1409: l_sql_stmt := 'SELECT /*+ parallel(AI) parallel(GPS) use_merge(AI,GPS) */ '

Line 1411: || 'FROM AP_INVOICES_ALL AI, '

1407: l_id_column := 'INVOICE_ID';
1408:
1409: l_sql_stmt := 'SELECT /*+ parallel(AI) parallel(GPS) use_merge(AI,GPS) */ '
1410: || ' MIN(INVOICE_ID), MAX(INVOICE_ID) '
1411: || 'FROM AP_INVOICES_ALL AI, '
1412: || 'XLA_UPGRADE_DATES GPS '
1413: || 'WHERE TRUNC(AI.GL_DATE) BETWEEN GPS.Start_Date AND GPS.End_Date '
1414: || 'AND GPS.Ledger_ID = AI.Set_Of_Books_ID';
1415: