APPS.AP_LINES_UPGRADE_PKG dependencies on AP_INVOICES_ALL

Line 613: FROM AP_Invoices_ALL AI,

609: DECODE(AID1.Invoice_Distribution_ID, NULL, ZX_Lines_Summary_S.Nextval, NULL),
610: ZX_Lines_Summary_S.Nextval)),
611: ZX_Lines_Summary_S.Nextval),
612: NULL) Summary_Tax_Line_ID
613: FROM AP_Invoices_ALL AI,
614: AP_Inv_Dists_Source AID,
615: AP_Inv_Dists_Source AID1,
616: ZX_Rates_B ZXR
617: WHERE AI.Invoice_ID = AID.Invoice_ID

Line 858: FROM AP_Invoices_All AI,

854: / DECODE(AID.Base_Amount, 0, 1, AID.Base_Amount)
855: END) As ERV_Amount,
856: AI.Invoice_Currency_Code Invoice_Currency_Code,
857: AI.Set_Of_Books_ID Set_Of_Books_ID
858: FROM AP_Invoices_All AI,
859: AP_Chrg_Allocations_All ACA,
860: AP_Dist_Line_GT AID,
861: AP_Chrg_Allocations_All ACA1,
862: AP_Dist_Line_GT AID1

Line 1424: AP_Invoices_All AI,

1420: ZXR.Percentage_Rate, NULL) Tax_Rate,
1421: ZXR.Source_ID Tax_Code_ID, --Bug 7111010
1422: 'Y'
1423: FROM AP_System_Parameters_All ASP,
1424: AP_Invoices_All AI,
1425: AP_Dist_Line_GT AID,
1426: RCV_Transactions RCT, -- bug 6896361 added to get rcv_shipment_line_id from this table
1427: PO_Distributions_All PD,
1428: PO_Lines_All PL,

Line 1883: FROM AP_Invoices_ALL AI,

1879: AI.global_attribute10
1880: END) AS Intended_Use,
1881: 'Y' Historical_Flag,
1882: 'N' RCV_Charge_Addition_Flag
1883: FROM AP_Invoices_ALL AI,
1884: AP_Dist_Line_GT AID,
1885: AP_Tax_Alloc_Amount_GT ACA,
1886: AP_Line_Temp_GT Line
1887: WHERE AI.Invoice_ID = AID.Invoice_ID

Line 2307: AP_Invoices_ALL AI,

2303: END) AS Intended_Use,
2304: 'Y' Historical_Flag,
2305: 'N' RCV_Charge_Addition_Flag
2306: FROM AP_System_Parameters_All ASP,
2307: AP_Invoices_ALL AI,
2308: FND_Currencies FC,
2309: AP_Dist_Line_GT AID,
2310: AP_Tax_Alloc_Amount_GT TAA,
2311: AP_Tax_Alloc_Amount_GT TAA1,

Line 2321: FROM AP_Invoices_All AI,

2317: SUM(NVL(ACA.Allocated_Amount,AID.Amount)) Sum_Alloc_Amount,
2318: SUM(NVL(ACA.Allocated_Base_Amount,AID.Base_Amount)) Sum_Alloc_Base_Amount,
2319: AID.Tax_Recovery_Rate Rec_NRec_Rate,
2320: AID.Set_Of_Books_ID
2321: FROM AP_Invoices_All AI,
2322: AP_Inv_Dists_Source AID,
2323: AP_Chrg_Allocations_All ACA,
2324: AP_Inv_Dists_Source AID1
2325: WHERE AI.Invoice_ID = AID.Invoice_ID

Line 2514: l_table_name VARCHAR2(30) := 'AP_INVOICES_ALL';

2510:
2511: l_table_owner VARCHAR2(30);
2512: l_any_rows_to_process BOOLEAN;
2513:
2514: l_table_name VARCHAR2(30) := 'AP_INVOICES_ALL';
2515: l_script_name VARCHAR2(30) := 'apilnupg.sql';
2516:
2517: l_start_rowid ROWID;
2518: l_end_rowid ROWID;

Line 2752: 'AP_INVOICES_ALL',

2748:
2749: ad_parallel_updates_pkg.delete_update_information
2750: (ad_parallel_updates_pkg.ROWID_RANGE,
2751: l_table_owner,
2752: 'AP_INVOICES_ALL',
2753: 'apilnupg.sql');
2754:
2755: END IF;
2756: