eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.AP_LINES_UPGRADE_SYNC_PKG dependencies on AP_DIST_LINE_GT

Line 145: INSERT INTO AP_Dist_Line_GT t1

141: whenever we need information about the line number for a distribution
142: rather than calculating it each time */
143:
144:
145: INSERT INTO AP_Dist_Line_GT t1
146: (ACCOUNTING_DATE,
147: ACCRUAL_POSTED_FLAG,
148: ASSETS_ADDITION_FLAG,
149: ASSETS_TRACKING_FLAG,

Line 823: AP_Dist_Line_GT AID,

819: AI.Invoice_Currency_Code Invoice_Currency_Code,
820: AI.Set_Of_Books_ID Set_Of_Books_ID
821: FROM AP_Invoices_All AI,
822: AP_Chrg_Allocations_All ACA,
823: AP_Dist_Line_GT AID,
824: AP_Chrg_Allocations_All ACA1,
825: AP_Dist_Line_GT AID1,
826: AP_Chrg_Allocations_All ACA2
827: WHERE AI.Invoice_ID = AID.Invoice_ID

Line 825: AP_Dist_Line_GT AID1,

821: FROM AP_Invoices_All AI,
822: AP_Chrg_Allocations_All ACA,
823: AP_Dist_Line_GT AID,
824: AP_Chrg_Allocations_All ACA1,
825: AP_Dist_Line_GT AID1,
826: AP_Chrg_Allocations_All ACA2
827: WHERE AI.Invoice_ID = AID.Invoice_ID
828: -- AND AID.Line_Type_Lookup_Code IN ('FREIGHT', 'MISCELLANEOUS', 'TAX')
829: AND AID.Invoice_Distribution_ID = ACA.Charge_Dist_ID (+)

Line 1366: AP_Dist_Line_GT AID,

1362: ZXR.Tax_Rate_ID Tax_Code_ID,
1363: 'Y'
1364: FROM AP_System_Parameters_All ASP,
1365: AP_Invoices_All AI,
1366: AP_Dist_Line_GT AID,
1367: PO_Distributions_All PD,
1368: PO_Lines_All PL,
1369: AP_Inv_Dists_Source AID1,
1370: AP_Tax_Codes_All ATC,

Line 1809: AP_Dist_Line_GT AID,

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

Line 2224: AP_Dist_Line_GT AID,

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

Line 2227: AP_Dist_Line_GT AID1,

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

Line 2236: AP_Dist_Line_GT AID,

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