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_INVOICES_ALL

Line 567: FROM AP_Invoices_ALL AI,

563: DECODE(AID.Parent_Reversal_ID, NULL, ZX_Lines_Summary_S.Nextval,
564: DECODE(AID.Reversal_Flag, 'Y', NULL, ZX_Lines_Summary_S.Nextval)),
565: ZX_Lines_Summary_S.Nextval),
566: NULL) Summary_Tax_Line_ID
567: FROM AP_Invoices_ALL AI,
568: AP_Inv_Dists_Source AID,
569: AP_Inv_Dists_Source AID1,
570: ZX_Rates_B ZXR
571: WHERE AI.Invoice_ID IN (SELECT Distinct Invoice_ID

Line 800: FROM AP_Invoices_All AI,

796: / DECODE(AID.Base_Amount, 0, 1, AID.Base_Amount)
797: END) As ERV_Amount,
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,

Line 1367: AP_Invoices_All AI,

1363: ZXR.Percentage_Rate, NULL) Tax_Rate,
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,

Line 1810: FROM AP_Invoices_ALL AI,

1806: AI.global_attribute10
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

Line 2224: AP_Invoices_ALL AI,

2220: END) AS Intended_Use,
2221: 'Y' Historical_Flag,
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,

Line 2237: FROM AP_Invoices_All AI,

2233: SUM(NVL(ACA.Allocated_Amount,AID.Amount)) Sum_Alloc_Amount,
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