DBA Data[Home] [Help]

APPS.AP_INVOICE_PAYMENTS_PKG dependencies on AP_INVOICES

Line 11: invoice_num ap_invoices.invoice_num%TYPE,

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,
15: type_trans ap_lookup_codes.displayed_field%TYPE,

Line 12: invoice_id ap_invoices.invoice_id%TYPE,

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,
15: type_trans ap_lookup_codes.displayed_field%TYPE,
16: method ap_checks.payment_method_code%TYPE, --4552701

Line 39: ap_invoices_all ai,

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
43: AND aip.check_id = ac.check_id