APPS.AP_LINES_UPGRADE_PKG dependencies on AP_DIST_LINE_GT

Line 178: INSERT INTO AP_Dist_Line_GT t1

174: whenever we need information about the line number for a distribution
175: rather than calculating it each time */
176:
177:
178: INSERT INTO AP_Dist_Line_GT t1
179: (ACCOUNTING_DATE,
180: ACCRUAL_POSTED_FLAG,
181: ASSETS_ADDITION_FLAG,
182: ASSETS_TRACKING_FLAG,

Line 922: AP_Dist_Line_GT AID,

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,
925: AP_Dist_Line_GT AID2 --8608129
926: -- AP_Chrg_Allocations_All ACA2

Line 924: AP_Dist_Line_GT AID1,

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,
925: AP_Dist_Line_GT AID2 --8608129
926: -- AP_Chrg_Allocations_All ACA2
927: WHERE AI.Invoice_ID = AID.Invoice_ID
928: -- AND AID.Line_Type_Lookup_Code IN ('FREIGHT', 'MISCELLANEOUS', 'TAX')

Line 925: AP_Dist_Line_GT AID2 --8608129

921: AP_Chrg_Allocations_All ACA,
922: AP_Dist_Line_GT AID,
923: AP_Chrg_Allocations_All ACA1,
924: AP_Dist_Line_GT AID1,
925: AP_Dist_Line_GT AID2 --8608129
926: -- AP_Chrg_Allocations_All ACA2
927: WHERE AI.Invoice_ID = AID.Invoice_ID
928: -- AND AID.Line_Type_Lookup_Code IN ('FREIGHT', 'MISCELLANEOUS', 'TAX')
929: AND AID.Invoice_Distribution_ID = ACA.Charge_Dist_ID (+)

Line 1514: AP_Dist_Line_GT AID,

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,
1518: AP_Inv_Dists_Source AID1,

Line 1985: AP_Dist_Line_GT AID,

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
1989: WHERE AI.Invoice_ID = AID.Invoice_ID

Line 2395: AP_Dist_Line_GT AID,

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,
2398: AP_Dist_Line_GT AID1,
2399: (SELECT /*+ cardinality(AI,1) rowid(AI) USE_NL(AI, AID, ACA, AID1)

Line 2398: AP_Dist_Line_GT AID1,

2394: FND_Currencies FC,
2395: AP_Dist_Line_GT AID,
2396: AP_Tax_Alloc_Amount_GT TAA,
2397: AP_Tax_Alloc_Amount_GT TAA1,
2398: AP_Dist_Line_GT AID1,
2399: (SELECT /*+ cardinality(AI,1) rowid(AI) USE_NL(AI, AID, ACA, AID1)
2400: index(aid AP_INVOICE_DISTS_ARCH_U1) index(aid1 ap_invoice_dists_arch_u2)*/ -- Bug 13837821/16025353 Hint modified for perf
2401: AID.Invoice_Distribution_ID Item_Dist_ID,
2402: AID.Amount Item_Amount,