APPS.AP_LINES_UPGRADE_SYNC_PKG dependencies on AP_DIST_LINE_GT

Line 124: INSERT INTO AP_Dist_Line_GT t1

120: whenever we need information about the line number for a distribution
121: rather than calculating it each time */
122:
123:
124: INSERT INTO AP_Dist_Line_GT t1
125: (ACCOUNTING_DATE,
126: ACCRUAL_POSTED_FLAG,
127: ASSETS_ADDITION_FLAG,
128: ASSETS_TRACKING_FLAG,

Line 802: AP_Dist_Line_GT AID,

798: AI.Invoice_Currency_Code Invoice_Currency_Code,
799: AI.Set_Of_Books_ID Set_Of_Books_ID
800: FROM AP_Invoices_All AI,
801: AP_Chrg_Allocations_All ACA,
802: AP_Dist_Line_GT AID,
803: AP_Chrg_Allocations_All ACA1,
804: AP_Dist_Line_GT AID1,
805: AP_Chrg_Allocations_All ACA2
806: WHERE AI.Invoice_ID = AID.Invoice_ID

Line 804: AP_Dist_Line_GT AID1,

800: FROM AP_Invoices_All AI,
801: AP_Chrg_Allocations_All ACA,
802: AP_Dist_Line_GT AID,
803: AP_Chrg_Allocations_All ACA1,
804: AP_Dist_Line_GT AID1,
805: AP_Chrg_Allocations_All ACA2
806: WHERE AI.Invoice_ID = AID.Invoice_ID
807: -- AND AID.Line_Type_Lookup_Code IN ('FREIGHT', 'MISCELLANEOUS', 'TAX')
808: AND AID.Invoice_Distribution_ID = ACA.Charge_Dist_ID (+)

Line 1368: AP_Dist_Line_GT AID,

1364: ZXR.Source_ID Tax_Code_ID, --Bug 7111010
1365: 'Y'
1366: FROM AP_System_Parameters_All ASP,
1367: AP_Invoices_All AI,
1368: AP_Dist_Line_GT AID,
1369: PO_Distributions_All PD,
1370: PO_Lines_All PL,
1371: AP_Inv_Dists_Source AID1,
1372: AP_Tax_Codes_All ATC,

Line 1811: AP_Dist_Line_GT AID,

1807: END) AS Intended_Use,
1808: 'Y' Historical_Flag,
1809: 'N' RCV_Charge_Addition_Flag
1810: FROM AP_Invoices_ALL AI,
1811: AP_Dist_Line_GT AID,
1812: AP_Tax_Alloc_Amount_GT ACA,
1813: AP_Line_Temp_GT Line
1814: WHERE AI.Invoice_ID = AID.Invoice_ID
1815: AND AID.Line_Type_Lookup_Code IN ('ITEM', 'PREPAY', 'AWT', 'ICMS',

Line 2226: AP_Dist_Line_GT AID,

2222: 'N' RCV_Charge_Addition_Flag
2223: FROM AP_System_Parameters_All ASP,
2224: AP_Invoices_ALL AI,
2225: FND_Currencies FC,
2226: AP_Dist_Line_GT AID,
2227: AP_Tax_Alloc_Amount_GT TAA,
2228: AP_Tax_Alloc_Amount_GT TAA1,
2229: AP_Dist_Line_GT AID1,
2230: (SELECT AID.Invoice_Distribution_ID Item_Dist_ID,

Line 2229: AP_Dist_Line_GT AID1,

2225: FND_Currencies FC,
2226: AP_Dist_Line_GT AID,
2227: AP_Tax_Alloc_Amount_GT TAA,
2228: AP_Tax_Alloc_Amount_GT TAA1,
2229: AP_Dist_Line_GT AID1,
2230: (SELECT AID.Invoice_Distribution_ID Item_Dist_ID,
2231: AID.Amount Item_Amount,
2232: AID.Base_Amount Item_Base_Amount,
2233: SUM(NVL(ACA.Allocated_Amount,AID.Amount)) Sum_Alloc_Amount,

Line 2238: AP_Dist_Line_GT AID,

2234: SUM(NVL(ACA.Allocated_Base_Amount,AID.Base_Amount)) Sum_Alloc_Base_Amount,
2235: AID.Tax_Recovery_Rate Rec_NRec_Rate,
2236: AID.Set_Of_Books_ID
2237: FROM AP_Invoices_All AI,
2238: AP_Dist_Line_GT AID,
2239: AP_Chrg_Allocations_All ACA,
2240: AP_Inv_Dists_Source AID1
2241: WHERE AI.Invoice_ID = AID.Invoice_ID
2242: AND AID.Invoice_Distribution_ID = ACA.Item_Dist_ID