APPS.AP_LINES_UPGRADE_PKG dependencies on AP_INVOICES_ALL

Line 166: FROM AP_Invoices_ALL AI

162: AND AID.awt_invoice_payment_id IS NOT NULL
163: AND AID.reversal_flag = 'N'
164: AND AID.invoice_id IN (
165: SELECT /*+ ROWID(AI) */ AI.Invoice_ID
166: FROM AP_Invoices_ALL AI
167: WHERE AI.Rowid BETWEEN p_start_rowid AND p_end_rowid
168: AND AI.invoice_id = AID.invoice_id);
169:
170: /* BUG 9080712 - END */

Line 667: FROM AP_Invoices_ALL AI,

663: DECODE(AID1.Invoice_Distribution_ID, NULL, ZX_Lines_Summary_S.Nextval, NULL),
664: ZX_Lines_Summary_S.Nextval)),
665: ZX_Lines_Summary_S.Nextval),
666: NULL) Summary_Tax_Line_ID
667: FROM AP_Invoices_ALL AI,
668: AP_Inv_Dists_Source AID,
669: AP_Inv_Dists_Source AID1,
670: PO_Distributions_All POD, -- 9196221
671: ZX_Rates_B ZXR

Line 920: FROM AP_Invoices_All AI,

916: AI.Invoice_Currency_Code Invoice_Currency_Code,
917: AI.Set_Of_Books_ID Set_Of_Books_ID,
918: nvl(AID2.Parent_Reversal_ID, AID2.Invoice_Distribution_ID) org_item_id, --8608129
919: AID.parent_reversal_id parent_reversal_id --8608129
920: FROM AP_Invoices_All AI,
921: AP_Chrg_Allocations_All ACA,
922: AP_Dist_Line_GT AID,
923: AP_Chrg_Allocations_All ACA1,
924: AP_Dist_Line_GT AID1,

Line 1513: AP_Invoices_All AI,

1509: ZXR.Percentage_Rate, NULL) Tax_Rate,
1510: ZXR.Source_ID Tax_Code_ID, --Bug 7111010
1511: 'Y'
1512: FROM AP_System_Parameters_All ASP,
1513: AP_Invoices_All AI,
1514: AP_Dist_Line_GT AID,
1515: RCV_Transactions RCT, -- bug 6896361 added to get rcv_shipment_line_id from this table
1516: PO_Distributions_All PD,
1517: PO_Lines_All PL,

Line 1984: FROM AP_Invoices_ALL AI,

1980: END) AS Intended_Use,
1981: 'Y' Historical_Flag,
1982: aid.INVOICE_INCLUDES_PREPAY_FLAG, --13774403 populating the flag for upgraded transactions
1983: 'N' RCV_Charge_Addition_Flag
1984: FROM AP_Invoices_ALL AI,
1985: AP_Dist_Line_GT AID,
1986: AP_Tax_Alloc_Amount_GT ACA,
1987: AP_Line_Temp_GT Line,
1988: PO_Distributions_All POD --13444893

Line 2393: AP_Invoices_ALL AI,

2389: 'Y' Historical_Flag,
2390: aid.INVOICE_INCLUDES_PREPAY_FLAG, --13774403 populating te flag for upgraded transactions
2391: 'N' RCV_Charge_Addition_Flag
2392: FROM AP_System_Parameters_All ASP,
2393: AP_Invoices_ALL AI,
2394: FND_Currencies FC,
2395: AP_Dist_Line_GT AID,
2396: AP_Tax_Alloc_Amount_GT TAA,
2397: AP_Tax_Alloc_Amount_GT TAA1,

Line 2408: FROM AP_Invoices_All AI,

2404: SUM(NVL(ACA.Allocated_Amount,AID.Amount)) Sum_Alloc_Amount,
2405: SUM(NVL(ACA.Allocated_Base_Amount,AID.Base_Amount)) Sum_Alloc_Base_Amount,
2406: AID.Tax_Recovery_Rate Rec_NRec_Rate,
2407: AID.Set_Of_Books_ID
2408: FROM AP_Invoices_All AI,
2409: AP_Inv_Dists_Source AID,
2410: AP_Chrg_Allocations_All ACA,
2411: AP_Inv_Dists_Source AID1
2412: WHERE AI.Invoice_ID = AID.Invoice_ID

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

2575:
2576: l_table_owner VARCHAR2(30);
2577: l_any_rows_to_process BOOLEAN;
2578:
2579: l_table_name VARCHAR2(30) := 'AP_INVOICES_ALL';
2580: l_script_name VARCHAR2(30) := 'apilnupg.sql';
2581:
2582: l_start_rowid ROWID;
2583: l_end_rowid ROWID;

Line 2817: 'AP_INVOICES_ALL',

2813:
2814: ad_parallel_updates_pkg.delete_update_information
2815: (ad_parallel_updates_pkg.ROWID_RANGE,
2816: l_table_owner,
2817: 'AP_INVOICES_ALL',
2818: 'apilnupg.sql');
2819:
2820: END IF;
2821: