APPS.AP_LINES_UPGRADE_PKG dependencies on AP_DIST_LINE_GT

Line 161: INSERT INTO AP_Dist_Line_GT t1

157: whenever we need information about the line number for a distribution
158: rather than calculating it each time */
159:
160:
161: INSERT INTO AP_Dist_Line_GT t1
162: (ACCOUNTING_DATE,
163: ACCRUAL_POSTED_FLAG,
164: ASSETS_ADDITION_FLAG,
165: ASSETS_TRACKING_FLAG,

Line 860: AP_Dist_Line_GT AID,

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
863: -- AP_Chrg_Allocations_All ACA2
864: WHERE AI.Invoice_ID = AID.Invoice_ID

Line 862: AP_Dist_Line_GT AID1

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
863: -- AP_Chrg_Allocations_All ACA2
864: WHERE AI.Invoice_ID = AID.Invoice_ID
865: -- AND AID.Line_Type_Lookup_Code IN ('FREIGHT', 'MISCELLANEOUS', 'TAX')
866: AND AID.Invoice_Distribution_ID = ACA.Charge_Dist_ID (+)

Line 1425: AP_Dist_Line_GT AID,

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

Line 1884: AP_Dist_Line_GT AID,

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
1888: AND AID.Line_Type_Lookup_Code IN ('ITEM', 'PREPAY', 'AWT', 'ICMS',

Line 2309: AP_Dist_Line_GT AID,

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,
2312: AP_Dist_Line_GT AID1,
2313: (SELECT /*+ ROWID (AI) Ordered USE_NL(ACA,AID,AID1) */

Line 2312: AP_Dist_Line_GT AID1,

2308: FND_Currencies FC,
2309: AP_Dist_Line_GT AID,
2310: AP_Tax_Alloc_Amount_GT TAA,
2311: AP_Tax_Alloc_Amount_GT TAA1,
2312: AP_Dist_Line_GT AID1,
2313: (SELECT /*+ ROWID (AI) Ordered USE_NL(ACA,AID,AID1) */
2314: AID.Invoice_Distribution_ID Item_Dist_ID,
2315: AID.Amount Item_Amount,
2316: AID.Base_Amount Item_Base_Amount,