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_INVOICE_DISTRIBUTIONS

Line 18: (Invoice_ID AP_Invoice_Distributions.Invoice_ID%TYPE

14: );
15:
16:
17: TYPE r_prepay_dist_info IS RECORD
18: (Invoice_ID AP_Invoice_Distributions.Invoice_ID%TYPE
19: ,Invoice_Distribution_ID AP_Invoice_Distributions.Invoice_Distribution_ID%TYPE
20: ,Line_Type_Lookup_Code AP_Invoice_Distributions.Line_Type_Lookup_Code%TYPE
21: ,Amount AP_Invoice_Distributions.Amount%TYPE
22: ,Base_Amount AP_Invoice_Distributions.Base_Amount%TYPE

Line 19: ,Invoice_Distribution_ID AP_Invoice_Distributions.Invoice_Distribution_ID%TYPE

15:
16:
17: TYPE r_prepay_dist_info IS RECORD
18: (Invoice_ID AP_Invoice_Distributions.Invoice_ID%TYPE
19: ,Invoice_Distribution_ID AP_Invoice_Distributions.Invoice_Distribution_ID%TYPE
20: ,Line_Type_Lookup_Code AP_Invoice_Distributions.Line_Type_Lookup_Code%TYPE
21: ,Amount AP_Invoice_Distributions.Amount%TYPE
22: ,Base_Amount AP_Invoice_Distributions.Base_Amount%TYPE
23: ,Accounting_Event_ID AP_Invoice_Distributions.Accounting_Event_ID%TYPE

Line 20: ,Line_Type_Lookup_Code AP_Invoice_Distributions.Line_Type_Lookup_Code%TYPE

16:
17: TYPE r_prepay_dist_info IS RECORD
18: (Invoice_ID AP_Invoice_Distributions.Invoice_ID%TYPE
19: ,Invoice_Distribution_ID AP_Invoice_Distributions.Invoice_Distribution_ID%TYPE
20: ,Line_Type_Lookup_Code AP_Invoice_Distributions.Line_Type_Lookup_Code%TYPE
21: ,Amount AP_Invoice_Distributions.Amount%TYPE
22: ,Base_Amount AP_Invoice_Distributions.Base_Amount%TYPE
23: ,Accounting_Event_ID AP_Invoice_Distributions.Accounting_Event_ID%TYPE
24: ,Prepay_Distribution_ID AP_Invoice_Distributions.Prepay_Distribution_ID%TYPE

Line 21: ,Amount AP_Invoice_Distributions.Amount%TYPE

17: TYPE r_prepay_dist_info IS RECORD
18: (Invoice_ID AP_Invoice_Distributions.Invoice_ID%TYPE
19: ,Invoice_Distribution_ID AP_Invoice_Distributions.Invoice_Distribution_ID%TYPE
20: ,Line_Type_Lookup_Code AP_Invoice_Distributions.Line_Type_Lookup_Code%TYPE
21: ,Amount AP_Invoice_Distributions.Amount%TYPE
22: ,Base_Amount AP_Invoice_Distributions.Base_Amount%TYPE
23: ,Accounting_Event_ID AP_Invoice_Distributions.Accounting_Event_ID%TYPE
24: ,Prepay_Distribution_ID AP_Invoice_Distributions.Prepay_Distribution_ID%TYPE
25: ,Prepay_Tax_Diff_Amount AP_Invoice_Distributions.Prepay_Tax_Diff_Amount%TYPE

Line 22: ,Base_Amount AP_Invoice_Distributions.Base_Amount%TYPE

18: (Invoice_ID AP_Invoice_Distributions.Invoice_ID%TYPE
19: ,Invoice_Distribution_ID AP_Invoice_Distributions.Invoice_Distribution_ID%TYPE
20: ,Line_Type_Lookup_Code AP_Invoice_Distributions.Line_Type_Lookup_Code%TYPE
21: ,Amount AP_Invoice_Distributions.Amount%TYPE
22: ,Base_Amount AP_Invoice_Distributions.Base_Amount%TYPE
23: ,Accounting_Event_ID AP_Invoice_Distributions.Accounting_Event_ID%TYPE
24: ,Prepay_Distribution_ID AP_Invoice_Distributions.Prepay_Distribution_ID%TYPE
25: ,Prepay_Tax_Diff_Amount AP_Invoice_Distributions.Prepay_Tax_Diff_Amount%TYPE
26: ,Parent_Reversal_ID AP_Invoice_Distributions.Parent_Reversal_ID%TYPE

Line 23: ,Accounting_Event_ID AP_Invoice_Distributions.Accounting_Event_ID%TYPE

19: ,Invoice_Distribution_ID AP_Invoice_Distributions.Invoice_Distribution_ID%TYPE
20: ,Line_Type_Lookup_Code AP_Invoice_Distributions.Line_Type_Lookup_Code%TYPE
21: ,Amount AP_Invoice_Distributions.Amount%TYPE
22: ,Base_Amount AP_Invoice_Distributions.Base_Amount%TYPE
23: ,Accounting_Event_ID AP_Invoice_Distributions.Accounting_Event_ID%TYPE
24: ,Prepay_Distribution_ID AP_Invoice_Distributions.Prepay_Distribution_ID%TYPE
25: ,Prepay_Tax_Diff_Amount AP_Invoice_Distributions.Prepay_Tax_Diff_Amount%TYPE
26: ,Parent_Reversal_ID AP_Invoice_Distributions.Parent_Reversal_ID%TYPE
27: );

Line 24: ,Prepay_Distribution_ID AP_Invoice_Distributions.Prepay_Distribution_ID%TYPE

20: ,Line_Type_Lookup_Code AP_Invoice_Distributions.Line_Type_Lookup_Code%TYPE
21: ,Amount AP_Invoice_Distributions.Amount%TYPE
22: ,Base_Amount AP_Invoice_Distributions.Base_Amount%TYPE
23: ,Accounting_Event_ID AP_Invoice_Distributions.Accounting_Event_ID%TYPE
24: ,Prepay_Distribution_ID AP_Invoice_Distributions.Prepay_Distribution_ID%TYPE
25: ,Prepay_Tax_Diff_Amount AP_Invoice_Distributions.Prepay_Tax_Diff_Amount%TYPE
26: ,Parent_Reversal_ID AP_Invoice_Distributions.Parent_Reversal_ID%TYPE
27: );
28:

Line 25: ,Prepay_Tax_Diff_Amount AP_Invoice_Distributions.Prepay_Tax_Diff_Amount%TYPE

21: ,Amount AP_Invoice_Distributions.Amount%TYPE
22: ,Base_Amount AP_Invoice_Distributions.Base_Amount%TYPE
23: ,Accounting_Event_ID AP_Invoice_Distributions.Accounting_Event_ID%TYPE
24: ,Prepay_Distribution_ID AP_Invoice_Distributions.Prepay_Distribution_ID%TYPE
25: ,Prepay_Tax_Diff_Amount AP_Invoice_Distributions.Prepay_Tax_Diff_Amount%TYPE
26: ,Parent_Reversal_ID AP_Invoice_Distributions.Parent_Reversal_ID%TYPE
27: );
28:
29:

Line 26: ,Parent_Reversal_ID AP_Invoice_Distributions.Parent_Reversal_ID%TYPE

22: ,Base_Amount AP_Invoice_Distributions.Base_Amount%TYPE
23: ,Accounting_Event_ID AP_Invoice_Distributions.Accounting_Event_ID%TYPE
24: ,Prepay_Distribution_ID AP_Invoice_Distributions.Prepay_Distribution_ID%TYPE
25: ,Prepay_Tax_Diff_Amount AP_Invoice_Distributions.Prepay_Tax_Diff_Amount%TYPE
26: ,Parent_Reversal_ID AP_Invoice_Distributions.Parent_Reversal_ID%TYPE
27: );
28:
29:
30: -- bug7349279, added the order by condition

Line 67: FROM AP_Invoice_Distributions_All AID

63: AID.Accounting_Event_ID,
64: AID.Prepay_Distribution_ID,
65: AID.Prepay_Tax_Diff_Amount,
66: AID.Parent_Reversal_ID
67: FROM AP_Invoice_Distributions_All AID
68: WHERE Invoice_ID = P_Invoice_ID
69: AND Invoice_Line_Number = P_Invoice_Line_Number
70: AND Line_Type_Lookup_Code = 'PREPAY'
71: AND Accounting_Date = P_Accounting_Date

Line 75: AP_Invoice_Distributions_All AID1

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
79: AND AID1.Invoice_Line_Number = APH.Prepay_Line_Num

Line 93: FROM AP_Invoice_Distributions_All AID

89: AID.Accounting_Event_ID,
90: AID.Prepay_Distribution_ID,
91: AID.Prepay_Tax_Diff_Amount,
92: AID.Parent_Reversal_ID
93: FROM AP_Invoice_Distributions_All AID
94: WHERE Invoice_ID = P_Invoice_ID
95: AND Line_Type_Lookup_Code IN ('NONREC_TAX','REC_TAX')
96: AND Accounting_Event_ID IS NULL
97: AND Charge_Applicable_To_Dist_ID IN

Line 99: FROM AP_Invoice_Distributions_All AID1

95: AND Line_Type_Lookup_Code IN ('NONREC_TAX','REC_TAX')
96: AND Accounting_Event_ID IS NULL
97: AND Charge_Applicable_To_Dist_ID IN
98: (SELECT AID1.Invoice_Distribution_ID
99: FROM AP_Invoice_Distributions_All AID1
100: WHERE Invoice_ID = P_Invoice_ID
101: AND Invoice_Line_Number = P_Invoice_Line_Number
102: AND Line_Type_Lookup_Code = 'PREPAY'
103: AND Accounting_Date = P_Accounting_Date

Line 107: AP_Invoice_Distributions_All AID2

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
111: AND AID2.Invoice_Line_Number = APH.Prepay_Line_Num

Line 137: FROM AP_Invoice_Distributions_All AID

133: AID.Amount_Variance,
134: AID.Base_Amount_Variance,
135: AID.Historical_Flag,
136: AID.Accounting_Event_Id
137: FROM AP_Invoice_Distributions_All AID
138: WHERE AID.Invoice_ID = P_Invoice_ID
139: AND NVL(AID.Accounting_Event_ID, -99) =
140: DECODE(P_Event_ID, NULL, NVL(AID.Accounting_Event_ID, -99),
141: P_Event_ID)