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_WEB_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 15: method ap_checks.payment_method_lookup_code%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: method ap_checks.payment_method_lookup_code%TYPE,
16: method_trans ap_lookup_codes.displayed_field%TYPE);
17:
18: -----------------------------------------------------------------------
19: -- Declare generic cursor to get check number, check id, invoice number

Line 35: ap_checks ac,

31: aip.invoice_payment_type,
32: ac.payment_method_lookup_code,
33: alc2.displayed_field
34: FROM ap_invoice_payments aip,
35: ap_checks ac,
36: ap_invoices ai,
37: ap_lookup_codes alc2
38: WHERE aip.invoice_id = l_invoice_id
39: AND aip.payment_num = l_payment_num

Line 55: ap_checks ac,

51: aip.invoice_payment_type,
52: ac.payment_method_lookup_code,
53: alc2.displayed_field
54: FROM ap_invoice_payments aip,
55: ap_checks ac,
56: ap_invoices ai,
57: ap_lookup_codes alc2,
58: ap_invoice_lines ail1,
59: ap_invoice_lines ail2,

Line 195: ap_checks ac

191: INTO l_check_id
192: FROM
193: ( SELECT ac.check_id check_id
194: FROM ap_invoice_payments aip,
195: ap_checks ac
196: WHERE aip.check_id = ac.check_id
197: AND aip.invoice_id = l_invoice_id
198: UNION ALL
199: SELECT ac.check_id check_id

Line 201: ap_checks ac,

197: AND aip.invoice_id = l_invoice_id
198: UNION ALL
199: SELECT ac.check_id check_id
200: FROM ap_invoice_payments aip,
201: ap_checks ac,
202: ap_invoice_lines ail1,
203: ap_invoice_lines ail2,
204: ap_invoice_distributions aid1,
205: ap_invoice_distributions aid2

Line 246: ap_checks ac

242: INTO l_last_payment_date
243: FROM
244: ( SELECT ac.check_date check_date
245: FROM ap_invoice_payments aip,
246: ap_checks ac
247: WHERE aip.check_id = ac.check_id
248: AND aip.invoice_id = l_invoice_id
249: UNION ALL
250: SELECT ac.check_date check_date

Line 252: ap_checks ac,

248: AND aip.invoice_id = l_invoice_id
249: UNION ALL
250: SELECT ac.check_date check_date
251: FROM ap_invoice_payments aip,
252: ap_checks ac,
253: ap_invoice_lines ail1,
254: ap_invoice_lines ail2,
255: ap_invoice_distributions aid1,
256: ap_invoice_distributions aid2