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_ACCTG_PREPAY_DIST_PKG dependencies on AP_PREPAY_HISTORY_ALL

Line 46: FROM AP_Prepay_History_All APH

42: APH.Transaction_Type,
43: APH.Accounting_Date,
44: APH.Invoice_Adjustment_Event_ID,
45: APH.Related_Prepay_App_Event_ID
46: FROM AP_Prepay_History_All APH
47: WHERE APH.Invoice_ID = P_Invoice_ID
48: AND APH.Accounting_Event_ID IS NULL
49: ORDER BY transaction_type;
50:

Line 74: FROM AP_Prepay_History_All APH,

70: AND Line_Type_Lookup_Code = 'PREPAY'
71: AND Accounting_Date = P_Accounting_Date
72: AND Accounting_Event_ID IS NULL
73: AND EXISTS (SELECT 'Prepay History'
74: FROM AP_Prepay_History_All APH,
75: AP_Invoice_Distributions_All AID1
76: WHERE APH.Prepay_History_ID = P_Prepay_History_ID
77: AND AID1.Invoice_Distribution_ID = AID.Prepay_Distribution_ID
78: AND AID1.Invoice_ID = APH.Prepay_Invoice_ID

Line 106: FROM AP_Prepay_History_All APH,

102: AND Line_Type_Lookup_Code = 'PREPAY'
103: AND Accounting_Date = P_Accounting_Date
104: AND Accounting_Event_ID IS NULL
105: AND EXISTS (SELECT 'Prepay History'
106: FROM AP_Prepay_History_All APH,
107: AP_Invoice_Distributions_All AID2
108: WHERE APH.Prepay_History_ID = P_Prepay_History_ID
109: AND AID2.Invoice_Distribution_ID = AID1.Prepay_Distribution_ID
110: AND AID2.Invoice_ID = APH.Prepay_Invoice_ID