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_PAY_DIST_PKG dependencies on AP_INVOICE_PAYMENTS

Line 7: ,Invoice_Payment_ID AP_Invoice_Payments.Invoice_Payment_ID%TYPE

3:
4:
5: TYPE r_inv_pay_info IS RECORD
6: (Invoice_ID AP_Invoices.Invoice_ID%TYPE
7: ,Invoice_Payment_ID AP_Invoice_Payments.Invoice_Payment_ID%TYPE
8: ,Amount AP_Invoice_Payments.Amount%TYPE
9: ,Discount_Taken AP_Invoice_Payments.Discount_Taken%TYPE
10: ,Payment_Base_Amount AP_Invoice_Payments.Payment_Base_Amount%TYPE
11: ,Invoice_Base_Amount AP_Invoice_Payments.Invoice_Base_Amount%TYPE

Line 8: ,Amount AP_Invoice_Payments.Amount%TYPE

4:
5: TYPE r_inv_pay_info IS RECORD
6: (Invoice_ID AP_Invoices.Invoice_ID%TYPE
7: ,Invoice_Payment_ID AP_Invoice_Payments.Invoice_Payment_ID%TYPE
8: ,Amount AP_Invoice_Payments.Amount%TYPE
9: ,Discount_Taken AP_Invoice_Payments.Discount_Taken%TYPE
10: ,Payment_Base_Amount AP_Invoice_Payments.Payment_Base_Amount%TYPE
11: ,Invoice_Base_Amount AP_Invoice_Payments.Invoice_Base_Amount%TYPE
12: ,Exchange_Rate_Type AP_Invoice_Payments.Exchange_Rate_Type%TYPE

Line 9: ,Discount_Taken AP_Invoice_Payments.Discount_Taken%TYPE

5: TYPE r_inv_pay_info IS RECORD
6: (Invoice_ID AP_Invoices.Invoice_ID%TYPE
7: ,Invoice_Payment_ID AP_Invoice_Payments.Invoice_Payment_ID%TYPE
8: ,Amount AP_Invoice_Payments.Amount%TYPE
9: ,Discount_Taken AP_Invoice_Payments.Discount_Taken%TYPE
10: ,Payment_Base_Amount AP_Invoice_Payments.Payment_Base_Amount%TYPE
11: ,Invoice_Base_Amount AP_Invoice_Payments.Invoice_Base_Amount%TYPE
12: ,Exchange_Rate_Type AP_Invoice_Payments.Exchange_Rate_Type%TYPE
13: ,Exchange_Date AP_Invoice_Payments.Exchange_Date%TYPE

Line 10: ,Payment_Base_Amount AP_Invoice_Payments.Payment_Base_Amount%TYPE

6: (Invoice_ID AP_Invoices.Invoice_ID%TYPE
7: ,Invoice_Payment_ID AP_Invoice_Payments.Invoice_Payment_ID%TYPE
8: ,Amount AP_Invoice_Payments.Amount%TYPE
9: ,Discount_Taken AP_Invoice_Payments.Discount_Taken%TYPE
10: ,Payment_Base_Amount AP_Invoice_Payments.Payment_Base_Amount%TYPE
11: ,Invoice_Base_Amount AP_Invoice_Payments.Invoice_Base_Amount%TYPE
12: ,Exchange_Rate_Type AP_Invoice_Payments.Exchange_Rate_Type%TYPE
13: ,Exchange_Date AP_Invoice_Payments.Exchange_Date%TYPE
14: ,Exchange_Rate AP_Invoice_Payments.Exchange_Rate%TYPE

Line 11: ,Invoice_Base_Amount AP_Invoice_Payments.Invoice_Base_Amount%TYPE

7: ,Invoice_Payment_ID AP_Invoice_Payments.Invoice_Payment_ID%TYPE
8: ,Amount AP_Invoice_Payments.Amount%TYPE
9: ,Discount_Taken AP_Invoice_Payments.Discount_Taken%TYPE
10: ,Payment_Base_Amount AP_Invoice_Payments.Payment_Base_Amount%TYPE
11: ,Invoice_Base_Amount AP_Invoice_Payments.Invoice_Base_Amount%TYPE
12: ,Exchange_Rate_Type AP_Invoice_Payments.Exchange_Rate_Type%TYPE
13: ,Exchange_Date AP_Invoice_Payments.Exchange_Date%TYPE
14: ,Exchange_Rate AP_Invoice_Payments.Exchange_Rate%TYPE
15: ,Reversal_Flag AP_Invoice_Payments.Reversal_Flag%TYPE

Line 12: ,Exchange_Rate_Type AP_Invoice_Payments.Exchange_Rate_Type%TYPE

8: ,Amount AP_Invoice_Payments.Amount%TYPE
9: ,Discount_Taken AP_Invoice_Payments.Discount_Taken%TYPE
10: ,Payment_Base_Amount AP_Invoice_Payments.Payment_Base_Amount%TYPE
11: ,Invoice_Base_Amount AP_Invoice_Payments.Invoice_Base_Amount%TYPE
12: ,Exchange_Rate_Type AP_Invoice_Payments.Exchange_Rate_Type%TYPE
13: ,Exchange_Date AP_Invoice_Payments.Exchange_Date%TYPE
14: ,Exchange_Rate AP_Invoice_Payments.Exchange_Rate%TYPE
15: ,Reversal_Flag AP_Invoice_Payments.Reversal_Flag%TYPE
16: ,Reversal_Inv_Pmt_ID AP_Invoice_Payments.Reversal_Inv_Pmt_ID%TYPE

Line 13: ,Exchange_Date AP_Invoice_Payments.Exchange_Date%TYPE

9: ,Discount_Taken AP_Invoice_Payments.Discount_Taken%TYPE
10: ,Payment_Base_Amount AP_Invoice_Payments.Payment_Base_Amount%TYPE
11: ,Invoice_Base_Amount AP_Invoice_Payments.Invoice_Base_Amount%TYPE
12: ,Exchange_Rate_Type AP_Invoice_Payments.Exchange_Rate_Type%TYPE
13: ,Exchange_Date AP_Invoice_Payments.Exchange_Date%TYPE
14: ,Exchange_Rate AP_Invoice_Payments.Exchange_Rate%TYPE
15: ,Reversal_Flag AP_Invoice_Payments.Reversal_Flag%TYPE
16: ,Reversal_Inv_Pmt_ID AP_Invoice_Payments.Reversal_Inv_Pmt_ID%TYPE
17: );

Line 14: ,Exchange_Rate AP_Invoice_Payments.Exchange_Rate%TYPE

10: ,Payment_Base_Amount AP_Invoice_Payments.Payment_Base_Amount%TYPE
11: ,Invoice_Base_Amount AP_Invoice_Payments.Invoice_Base_Amount%TYPE
12: ,Exchange_Rate_Type AP_Invoice_Payments.Exchange_Rate_Type%TYPE
13: ,Exchange_Date AP_Invoice_Payments.Exchange_Date%TYPE
14: ,Exchange_Rate AP_Invoice_Payments.Exchange_Rate%TYPE
15: ,Reversal_Flag AP_Invoice_Payments.Reversal_Flag%TYPE
16: ,Reversal_Inv_Pmt_ID AP_Invoice_Payments.Reversal_Inv_Pmt_ID%TYPE
17: );
18:

Line 15: ,Reversal_Flag AP_Invoice_Payments.Reversal_Flag%TYPE

11: ,Invoice_Base_Amount AP_Invoice_Payments.Invoice_Base_Amount%TYPE
12: ,Exchange_Rate_Type AP_Invoice_Payments.Exchange_Rate_Type%TYPE
13: ,Exchange_Date AP_Invoice_Payments.Exchange_Date%TYPE
14: ,Exchange_Rate AP_Invoice_Payments.Exchange_Rate%TYPE
15: ,Reversal_Flag AP_Invoice_Payments.Reversal_Flag%TYPE
16: ,Reversal_Inv_Pmt_ID AP_Invoice_Payments.Reversal_Inv_Pmt_ID%TYPE
17: );
18:
19:

Line 16: ,Reversal_Inv_Pmt_ID AP_Invoice_Payments.Reversal_Inv_Pmt_ID%TYPE

12: ,Exchange_Rate_Type AP_Invoice_Payments.Exchange_Rate_Type%TYPE
13: ,Exchange_Date AP_Invoice_Payments.Exchange_Date%TYPE
14: ,Exchange_Rate AP_Invoice_Payments.Exchange_Rate%TYPE
15: ,Reversal_Flag AP_Invoice_Payments.Reversal_Flag%TYPE
16: ,Reversal_Inv_Pmt_ID AP_Invoice_Payments.Reversal_Inv_Pmt_ID%TYPE
17: );
18:
19:
20: -- Cursor to get invoice payments for the given event id

Line 36: FROM AP_Invoice_Payments_All AIP

32: AIP.Exchange_Date,
33: AIP.Exchange_Rate,
34: NVL(AIP.Reversal_Flag,'N'),
35: AIP.Reversal_Inv_Pmt_ID
36: FROM AP_Invoice_Payments_All AIP
37: WHERE Accounting_Event_ID = P_Event_ID
38: AND AIP.Invoice_ID = DECODE(P_Invoice_ID, NULL, AIP.Invoice_ID,
39: P_Invoice_ID);
40:

Line 59: FROM AP_Invoice_Payments_All AIP

55: AIP.Exchange_Date,
56: AIP.Exchange_Rate,
57: NVL(AIP.Reversal_Flag,'N'),
58: AIP.Reversal_Inv_Pmt_ID
59: FROM AP_Invoice_Payments_All AIP
60: WHERE AIP.Check_ID = P_Check_ID
61: --AND NVL(AIP.Reversal_Flag, 'N') <> 'Y' --bug 7029334
62: AND AIP.Accounting_Event_ID NOT IN
63: (SELECT APH.Accounting_Event_ID