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.POS_AP_INVOICES_PKG dependencies on AP_CHECKS_ALL

Line 648: ap_checks_all ac

644: SELECT ac.check_number,
645: ac.check_id,
646: ac.check_Date
647: FROM ap_invoice_payments_all aip,
648: ap_checks_all ac
649: WHERE aip.invoice_id = l_invoice_id
650: AND aip.check_id = ac.check_id;
651:
652: BEGIN

Line 712: ap_checks_all ac

708: ac.check_id,
709: ac.check_Date
710: --, alc2.displayed_field
711: FROM ap_invoice_payments_all aip,
712: ap_checks_all ac
713: --, ap_lookup_codes alc2
714: WHERE aip.invoice_id = l_invoice_id
715: AND aip.check_id = ac.check_id;
716: -- AND alc2.lookup_type = 'PAYMENT METHOD'

Line 797: ap_checks_all ac,

793: ac.check_id,
794: -- ac.check_Date,
795: alc2.displayed_field
796: FROM ap_invoice_payments_all aip,
797: ap_checks_all ac,
798: ap_lookup_codes alc2
799: WHERE aip.invoice_id = l_invoice_id
800: AND aip.check_id = ac.check_id
801: AND alc2.lookup_type(+) = 'PAYMENT METHOD'

Line 807: ap_checks_all ac

803:
804: cursor paymentdate_cursor_new is
805: SELECT distinct ac.check_Date
806: FROM ap_invoice_payments_all aip,
807: ap_checks_all ac
808: WHERE aip.invoice_id = l_invoice_id
809: AND aip.check_id = ac.check_id;
810:
811: