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

Line 6: (Prepay_History_ID AP_Prepay_History.Prepay_History_ID%TYPE

2: /* $Header: appredis.pls 120.11.12010000.3 2008/09/26 23:41:01 gagrawal ship $ */
3:
4:
5: TYPE r_prepay_hist_info IS RECORD
6: (Prepay_History_ID AP_Prepay_History.Prepay_History_ID%TYPE
7: ,Prepay_Invoice_ID AP_Prepay_History.Prepay_Invoice_ID%TYPE
8: ,Invoice_ID AP_Prepay_History.Invoice_ID%TYPE
9: ,Invoice_Line_Number AP_Prepay_History.Invoice_Line_Number%TYPE
10: ,Transaction_Type AP_Prepay_History.Transaction_Type%TYPE

Line 7: ,Prepay_Invoice_ID AP_Prepay_History.Prepay_Invoice_ID%TYPE

3:
4:
5: TYPE r_prepay_hist_info IS RECORD
6: (Prepay_History_ID AP_Prepay_History.Prepay_History_ID%TYPE
7: ,Prepay_Invoice_ID AP_Prepay_History.Prepay_Invoice_ID%TYPE
8: ,Invoice_ID AP_Prepay_History.Invoice_ID%TYPE
9: ,Invoice_Line_Number AP_Prepay_History.Invoice_Line_Number%TYPE
10: ,Transaction_Type AP_Prepay_History.Transaction_Type%TYPE
11: ,Accounting_Date AP_Prepay_History.Accounting_Date%TYPE

Line 8: ,Invoice_ID AP_Prepay_History.Invoice_ID%TYPE

4:
5: TYPE r_prepay_hist_info IS RECORD
6: (Prepay_History_ID AP_Prepay_History.Prepay_History_ID%TYPE
7: ,Prepay_Invoice_ID AP_Prepay_History.Prepay_Invoice_ID%TYPE
8: ,Invoice_ID AP_Prepay_History.Invoice_ID%TYPE
9: ,Invoice_Line_Number AP_Prepay_History.Invoice_Line_Number%TYPE
10: ,Transaction_Type AP_Prepay_History.Transaction_Type%TYPE
11: ,Accounting_Date AP_Prepay_History.Accounting_Date%TYPE
12: ,Invoice_Adjustment_Event_ID AP_Prepay_History.Invoice_Adjustment_Event_ID%TYPE

Line 9: ,Invoice_Line_Number AP_Prepay_History.Invoice_Line_Number%TYPE

5: TYPE r_prepay_hist_info IS RECORD
6: (Prepay_History_ID AP_Prepay_History.Prepay_History_ID%TYPE
7: ,Prepay_Invoice_ID AP_Prepay_History.Prepay_Invoice_ID%TYPE
8: ,Invoice_ID AP_Prepay_History.Invoice_ID%TYPE
9: ,Invoice_Line_Number AP_Prepay_History.Invoice_Line_Number%TYPE
10: ,Transaction_Type AP_Prepay_History.Transaction_Type%TYPE
11: ,Accounting_Date AP_Prepay_History.Accounting_Date%TYPE
12: ,Invoice_Adjustment_Event_ID AP_Prepay_History.Invoice_Adjustment_Event_ID%TYPE
13: ,Related_Prepay_App_Event_ID AP_Prepay_History.Related_Prepay_App_Event_ID%TYPE

Line 10: ,Transaction_Type AP_Prepay_History.Transaction_Type%TYPE

6: (Prepay_History_ID AP_Prepay_History.Prepay_History_ID%TYPE
7: ,Prepay_Invoice_ID AP_Prepay_History.Prepay_Invoice_ID%TYPE
8: ,Invoice_ID AP_Prepay_History.Invoice_ID%TYPE
9: ,Invoice_Line_Number AP_Prepay_History.Invoice_Line_Number%TYPE
10: ,Transaction_Type AP_Prepay_History.Transaction_Type%TYPE
11: ,Accounting_Date AP_Prepay_History.Accounting_Date%TYPE
12: ,Invoice_Adjustment_Event_ID AP_Prepay_History.Invoice_Adjustment_Event_ID%TYPE
13: ,Related_Prepay_App_Event_ID AP_Prepay_History.Related_Prepay_App_Event_ID%TYPE
14: );

Line 11: ,Accounting_Date AP_Prepay_History.Accounting_Date%TYPE

7: ,Prepay_Invoice_ID AP_Prepay_History.Prepay_Invoice_ID%TYPE
8: ,Invoice_ID AP_Prepay_History.Invoice_ID%TYPE
9: ,Invoice_Line_Number AP_Prepay_History.Invoice_Line_Number%TYPE
10: ,Transaction_Type AP_Prepay_History.Transaction_Type%TYPE
11: ,Accounting_Date AP_Prepay_History.Accounting_Date%TYPE
12: ,Invoice_Adjustment_Event_ID AP_Prepay_History.Invoice_Adjustment_Event_ID%TYPE
13: ,Related_Prepay_App_Event_ID AP_Prepay_History.Related_Prepay_App_Event_ID%TYPE
14: );
15:

Line 12: ,Invoice_Adjustment_Event_ID AP_Prepay_History.Invoice_Adjustment_Event_ID%TYPE

8: ,Invoice_ID AP_Prepay_History.Invoice_ID%TYPE
9: ,Invoice_Line_Number AP_Prepay_History.Invoice_Line_Number%TYPE
10: ,Transaction_Type AP_Prepay_History.Transaction_Type%TYPE
11: ,Accounting_Date AP_Prepay_History.Accounting_Date%TYPE
12: ,Invoice_Adjustment_Event_ID AP_Prepay_History.Invoice_Adjustment_Event_ID%TYPE
13: ,Related_Prepay_App_Event_ID AP_Prepay_History.Related_Prepay_App_Event_ID%TYPE
14: );
15:
16:

Line 13: ,Related_Prepay_App_Event_ID AP_Prepay_History.Related_Prepay_App_Event_ID%TYPE

9: ,Invoice_Line_Number AP_Prepay_History.Invoice_Line_Number%TYPE
10: ,Transaction_Type AP_Prepay_History.Transaction_Type%TYPE
11: ,Accounting_Date AP_Prepay_History.Accounting_Date%TYPE
12: ,Invoice_Adjustment_Event_ID AP_Prepay_History.Invoice_Adjustment_Event_ID%TYPE
13: ,Related_Prepay_App_Event_ID AP_Prepay_History.Related_Prepay_App_Event_ID%TYPE
14: );
15:
16:
17: TYPE r_prepay_dist_info IS RECORD

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