APPS.AP_XLA_UPGRADE_PKG dependencies on AP_INVOICES_ALL

Line 276: FROM AP_Invoices_All AI,

272: AID.Line_Type_Lookup_Code,
273: FC.Minimum_Accountable_Unit Min_Acct_Unit,
274: FC.Precision Precision,
275: 'A' Merge_Duplicate_Code --added by abhsaxen for bug#9073033
276: FROM AP_Invoices_All AI,
277: XLA_Upgrade_Dates UPG,
278: XLA_Transaction_Entities_upg XTE,
279: XLA_Events XLE,
280: -- AP_Accounting_Events_All AAE,

Line 362: FROM AP_Invoices_All AI,

358: AID.Line_Type_Lookup_Code,
359: FC.Minimum_Accountable_Unit Min_Acct_Unit,
360: FC.Precision Precision,
361: 'A' Merge_Duplicate_Code --added by abhsaxen for bug#9073033
362: FROM AP_Invoices_All AI,
363: XLA_Upgrade_Dates UPG,
364: XLA_Transaction_Entities_upg XTE,
365: XLA_Events XLE,
366: -- AP_Accounting_Events_All AAE,

Line 468: FROM AP_Invoices_All AI,

464: ELSE
465: 'A'
466: END
467: MERGE_DUPLICATE_CODE -- changed by abhsaxen for bug 9073033
468: FROM AP_Invoices_All AI,
469: XLA_Upgrade_Dates UPG,
470: XLA_Transaction_Entities_upg XTE,
471: XLA_Events XLE,
472: -- AP_Accounting_Events_All AAE,

Line 649: FROM AP_Invoices_All AI,

645: AID.Invoice_Line_Number,
646: AID.Accounting_Date,
647: Row_Number() OVER (PARTITION BY AID.Accounting_Event_ID, AID.Invoice_ID
648: ORDER BY Invoice_Line_Number) RNum
649: FROM AP_Invoices_All AI,
650: XLA_Upgrade_Dates UPG,
651: AP_Invoice_Distributions_All AID
652: WHERE AI.rowid between p_start_rowid and p_end_rowid
653: AND TRUNC(AI.GL_Date) BETWEEN UPG.Start_Date and UPG.End_Date

Line 768: FROM AP_Invoices_All AI,

764: NVL(AI.Base_Amount, AI.Invoice_Amount))) Accounted_Amt,
765: (NVL(AEL.Entered_Cr, 0) - NVL(AEL.Entered_Dr, 0)) * AID.Amount /
766: NVL2(AEL.Account_Overlay_Source_ID, DECODE(AID1.Amount,0,1,AID1.Amount),
767: DECODE(AI.Invoice_Amount,0,1,AI.Invoice_Amount)) Entered_Amt
768: FROM AP_Invoices_All AI,
769: XLA_Upgrade_Dates UPG,
770: AP_System_Parameters_All ASP,
771: FND_Currencies FC,/* bug#6660487 changed the order of FC */
772: XLA_Transaction_Entities_upg XTE,

Line 911: FROM AP_Invoices_All AI,

907: DECODE(AEL.Accounting_Class_Code, 'LIABILITY' ,XTE.Entity_ID, null) APPLIED_TO_ENTITY_ID,
908: DECODE(AEL.Accounting_Class_Code, 'LIABILITY' ,AID.Invoice_Distribution_ID, null)
909: APPLIED_TO_DIST_ID_NUM_1,
910: '-2222' GAIN_OR_LOSS_REF --Bug7169843 ends
911: FROM AP_Invoices_All AI,
912: XLA_Upgrade_Dates UPG,
913: XLA_Transaction_Entities_upg XTE,
914: XLA_Events XLE,
915: -- AP_Accounting_Events_All AAE,

Line 1184: AP_Invoices_All AI,

1180: FND_Currencies FC,
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

Line 2240: l_table_name := 'AP_INVOICES_ALL';

2236: 'Worker: '||P_Worker_Id||' P_Num_Workers is ' || P_Num_Workers );
2237: END IF;
2238:
2239:
2240: l_table_name := 'AP_INVOICES_ALL';
2241: l_script_name := p_inv_script_name;
2242: --l_id_column := 'INVOICE_ID'; Bug 8725986
2243:
2244: --Start 8725986