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_INVOICE_PAYMENTS_PKG dependencies on AP_CHECKS

Line 8: RECORD (check_number ap_checks.check_number%TYPE,

4: -----------------------------------------------------------------------
5: -- Declare record type used to hold records returned from generic cursor
6: --
7: TYPE PAYMENT_RECORD IS
8: RECORD (check_number ap_checks.check_number%TYPE,
9: check_id ap_checks.check_id%TYPE,
10: check_date ap_checks.check_date%TYPE,
11: invoice_num ap_invoices.invoice_num%TYPE,
12: invoice_id ap_invoices.invoice_id%TYPE,

Line 9: check_id ap_checks.check_id%TYPE,

5: -- Declare record type used to hold records returned from generic cursor
6: --
7: TYPE PAYMENT_RECORD IS
8: RECORD (check_number ap_checks.check_number%TYPE,
9: check_id ap_checks.check_id%TYPE,
10: check_date ap_checks.check_date%TYPE,
11: invoice_num ap_invoices.invoice_num%TYPE,
12: invoice_id ap_invoices.invoice_id%TYPE,
13: gl_date ap_invoice_payments.accounting_date%TYPE,

Line 10: check_date ap_checks.check_date%TYPE,

6: --
7: TYPE PAYMENT_RECORD IS
8: RECORD (check_number ap_checks.check_number%TYPE,
9: check_id ap_checks.check_id%TYPE,
10: check_date ap_checks.check_date%TYPE,
11: invoice_num ap_invoices.invoice_num%TYPE,
12: invoice_id ap_invoices.invoice_id%TYPE,
13: gl_date ap_invoice_payments.accounting_date%TYPE,
14: type ap_invoice_payments.invoice_payment_type%TYPE,

Line 16: method ap_checks.payment_method_code%TYPE, --4552701

12: invoice_id ap_invoices.invoice_id%TYPE,
13: gl_date ap_invoice_payments.accounting_date%TYPE,
14: type ap_invoice_payments.invoice_payment_type%TYPE,
15: type_trans ap_lookup_codes.displayed_field%TYPE,
16: method ap_checks.payment_method_code%TYPE, --4552701
17: method_trans ap_lookup_codes.displayed_field%TYPE);
18:
19: -----------------------------------------------------------------------
20: -- Declare generic cursor to get check number, check id, invoice number

Line 38: ap_checks_all ac,

34: iby.payment_method_name, --4552701
35: ac.payment_method_code, --4552701
36: iby.payment_method_name
37: FROM ap_invoice_payments_all aip,
38: ap_checks_all ac,
39: ap_invoices_all ai,
40: iby_payment_methods_vl iby
41: WHERE aip.invoice_id = l_invoice_id
42: AND aip.payment_num = l_payment_num