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 84: FROM AP_Invoice_Distributions_All AID

80: AID.Accounting_Event_ID,
81: AID.Prepay_Distribution_ID,
82: AID.Prepay_Tax_Diff_Amount,
83: AID.Parent_Reversal_ID
84: FROM AP_Invoice_Distributions_All AID
85: WHERE Invoice_ID = P_Invoice_ID
86: AND Invoice_Line_Number = P_Invoice_Line_Number
87: AND Line_Type_Lookup_Code = 'PREPAY'
88: AND Accounting_Date = P_Accounting_Date

Line 94: AP_Invoice_Distributions_All AID1

90: AND nvl(AID.Posted_flag, 'N') <> 'Y'
91: AND nvl(AID.Encumbered_flag, 'N') <> 'Y'
92: AND EXISTS (SELECT 'Prepay History'
93: FROM AP_Prepay_History_All APH,
94: AP_Invoice_Distributions_All AID1
95: WHERE APH.Prepay_History_ID = P_Prepay_History_ID
96: AND AID1.Invoice_Distribution_ID = AID.Prepay_Distribution_ID
97: AND AID1.Invoice_ID = APH.Prepay_Invoice_ID
98: AND AID1.Invoice_Line_Number = APH.Prepay_Line_Num

Line 112: FROM AP_Invoice_Distributions_All AID

108: AID.Accounting_Event_ID,
109: AID.Prepay_Distribution_ID,
110: AID.Prepay_Tax_Diff_Amount,
111: AID.Parent_Reversal_ID
112: FROM AP_Invoice_Distributions_All AID
113: WHERE Invoice_ID = P_Invoice_ID
114: AND Line_Type_Lookup_Code IN ('NONREC_TAX','REC_TAX')
115: --AND Accounting_Event_ID IS NULL
116: AND nvl(AID.Posted_flag, 'N') <> 'Y'

Line 120: FROM AP_Invoice_Distributions_All AID1

116: AND nvl(AID.Posted_flag, 'N') <> 'Y'
117: AND nvl(AID.Encumbered_flag, 'N') <> 'Y'
118: AND Charge_Applicable_To_Dist_ID IN
119: (SELECT AID1.Invoice_Distribution_ID
120: FROM AP_Invoice_Distributions_All AID1
121: WHERE Invoice_ID = P_Invoice_ID
122: AND Invoice_Line_Number = P_Invoice_Line_Number
123: AND Line_Type_Lookup_Code = 'PREPAY'
124: AND Accounting_Date = P_Accounting_Date

Line 128: AP_Invoice_Distributions_All AID2

124: AND Accounting_Date = P_Accounting_Date
125: --AND Accounting_Event_ID IS NULL Bug 10184420
126: AND EXISTS (SELECT 'Prepay History'
127: FROM AP_Prepay_History_All APH,
128: AP_Invoice_Distributions_All AID2
129: WHERE APH.Prepay_History_ID = P_Prepay_History_ID
130: AND AID2.Invoice_Distribution_ID = AID1.Prepay_Distribution_ID
131: AND AID2.Invoice_ID = APH.Prepay_Invoice_ID
132: AND AID2.Invoice_Line_Number = APH.Prepay_Line_Num

Line 159: FROM AP_Invoice_Distributions_All AID

155: AID.Amount_Variance,
156: AID.Base_Amount_Variance,
157: AID.Historical_Flag,
158: AID.Accounting_Event_Id
159: FROM AP_Invoice_Distributions_All AID
160: WHERE AID.Invoice_ID = P_Invoice_ID
161: AND NVL(AID.Accounting_Event_ID, -99) =
162: DECODE(P_Event_ID, NULL, NVL(AID.Accounting_Event_ID, -99),
163: P_Event_ID)