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_INVOICE_LINES

Line 58: ap_invoice_lines ail1,

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,
60: ap_invoice_distributions aid1,
61: ap_invoice_distributions aid2
62: WHERE aip.invoice_id = ail2.invoice_id

Line 59: ap_invoice_lines ail2,

55: ap_checks ac,
56: ap_invoices ai,
57: ap_lookup_codes alc2,
58: ap_invoice_lines ail1,
59: ap_invoice_lines ail2,
60: ap_invoice_distributions aid1,
61: ap_invoice_distributions aid2
62: WHERE aip.invoice_id = ail2.invoice_id
63: AND ail1.invoice_id = l_invoice_id

Line 202: ap_invoice_lines ail1,

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
206: WHERE aip.check_id = ac.check_id

Line 203: ap_invoice_lines ail2,

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
206: WHERE aip.check_id = ac.check_id
207: AND ail1.invoice_id = l_invoice_id

Line 253: ap_invoice_lines ail1,

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
257: WHERE aip.check_id = ac.check_id

Line 254: ap_invoice_lines ail2,

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
257: WHERE aip.check_id = ac.check_id
258: AND ail1.invoice_id = l_invoice_id

Line 437: FROM ap_invoice_distributions aid,ap_invoice_lines al

433:
434: BEGIN
435: SELECT SUM(NVL(aid.prepay_amount_remaining,aid.amount))
436: INTO l_prepay_amt_available
437: FROM ap_invoice_distributions aid,ap_invoice_lines al
438: WHERE aid.invoice_id = al.invoice_id
439: AND aid.invoice_line_number= al.line_number
440: and al.line_number=line_id
441: AND aid.line_type_lookup_code IN ('ITEM','TAX')