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_XLA_UPGRADE_PKG dependencies on AP_INVOICE_DISTRIBUTIONS_ALL

Line 254: AP_Invoice_Distributions_All AID,

250: XLA_Upgrade_Dates UPG,
251: AP_Accounting_Events_All AAE,
252: XLA_AE_Headers AEH,
253: XLA_AE_Lines AEL,
254: AP_Invoice_Distributions_All AID,
255: FND_Currencies FC
256: WHERE AI.Invoice_ID between p_start_id and p_end_id
257: AND AI.Set_Of_Books_ID = UPG.Ledger_ID
258: AND TRUNC(AI.GL_Date) BETWEEN UPG.Start_Date AND UPG.End_Date

Line 306: AP_Invoice_Distributions_All AID,

302: XLA_Upgrade_Dates UPG,
303: AP_Accounting_Events_All AAE,
304: XLA_AE_Headers AEH,
305: XLA_AE_Lines AEL,
306: AP_Invoice_Distributions_All AID,
307: FND_Currencies FC
308: WHERE AI.Invoice_ID between p_start_id and p_end_id
309: AND AI.Set_Of_Books_ID = UPG.Ledger_ID
310: AND TRUNC(AI.GL_Date) BETWEEN UPG.Start_Date AND UPG.End_Date

Line 366: AP_Invoice_Distributions_All AID,

362: XLA_Upgrade_Dates UPG,
363: AP_Accounting_Events_All AAE,
364: XLA_AE_Headers AEH,
365: XLA_AE_Lines AEL,
366: AP_Invoice_Distributions_All AID,
367: FND_Currencies FC
368: WHERE AI.Invoice_ID between p_start_id and p_end_id
369: AND AI.Set_Of_Books_ID = UPG.Ledger_ID
370: AND TRUNC(AI.GL_Date) BETWEEN UPG.Start_Date AND UPG.End_Date

Line 496: AP_Invoice_Distributions_All AID

492: Row_Number() OVER (PARTITION BY AID.Accounting_Event_ID, AID.Invoice_ID
493: ORDER BY Invoice_Line_Number) RNum
494: FROM AP_Invoices_All AI,
495: XLA_Upgrade_Dates UPG,
496: AP_Invoice_Distributions_All AID
497: WHERE AI.Invoice_ID BETWEEN p_start_id and p_end_id
498: AND TRUNC(AI.GL_Date) BETWEEN UPG.Start_Date and UPG.End_Date
499: AND AI.Set_Of_Books_ID = UPG.Ledger_ID
500: AND AID.Invoice_ID = AI.Invoice_ID

Line 612: AP_Invoice_Distributions_All AID,

608: XLA_Upgrade_Dates UPG,
609: AP_System_Parameters_All ASP,
610: AP_Accounting_Events_All AAE,
611: AP_Prepay_History_All APH,
612: AP_Invoice_Distributions_All AID,
613: AP_Inv_Dists_Source AID1,
614: XLA_AE_Headers AEH,
615: XLA_AE_Lines AEL,
616: AP_Invoice_Distributions_All AIDP,

Line 616: AP_Invoice_Distributions_All AIDP,

612: AP_Invoice_Distributions_All AID,
613: AP_Inv_Dists_Source AID1,
614: XLA_AE_Headers AEH,
615: XLA_AE_Lines AEL,
616: AP_Invoice_Distributions_All AIDP,
617: FND_Currencies FC
618: WHERE AI.Invoice_ID BETWEEN p_start_id AND p_end_id
619: AND AI.Set_Of_Books_ID = UPG.Ledger_ID
620: AND TRUNC(AI.GL_Date) BETWEEN UPG.Start_Date AND UPG.End_Date

Line 724: AP_Invoice_Distributions_All AID,

720: FROM AP_Invoices_All AI,
721: XLA_Upgrade_Dates UPG,
722: AP_Accounting_Events_All AAE,
723: AP_Prepay_App_Dists APAD,
724: AP_Invoice_Distributions_All AID,
725: XLA_AE_Headers AEH,
726: XLA_AE_Lines AEL
727: WHERE AI.Invoice_ID BETWEEN p_start_id AND p_end_id
728: AND TRUNC(AI.GL_Date) BETWEEN UPG.Start_Date and UPG.End_Date

Line 921: AP_Invoice_Distributions_All AID,

917: AP_Invoice_Payments_All AIP,
918: AP_Payment_History_All APH,
919: XLA_AE_Headers AEH,
920: XLA_AE_Lines AEL,
921: AP_Invoice_Distributions_All AID,
922: AP_Invoices_All AI,
923: AP_Inv_Dists_Source AID1,
924: FND_Currencies FC
925: WHERE AC.Check_ID BETWEEN p_start_id AND p_end_id

Line 1074: AP_Invoice_Distributions_All AID

1070: AP_Payment_History_All APH,
1071: XLA_AE_Headers AEH,
1072: XLA_AE_Lines AEL,
1073: AP_Payment_Hist_Dists APHD,
1074: AP_Invoice_Distributions_All AID
1075: WHERE AC.Check_ID BETWEEN p_start_id AND p_end_id
1076: AND TRUNC(AC.Check_Date) BETWEEN UPG.Start_Date and UPG.End_Date
1077: AND ASP.Set_Of_Books_ID = UPG.Ledger_ID
1078: AND AC.Org_ID = ASP.Org_ID