ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN 9E8D71C99DB07EADE053B46B63583417Y select aia.invoice_num, aia.invoice_currency_code, DECODE(aia.PAYMENT_STATUS_FLAG,'N','UN-PAID','P','Partial Paid','Y','PAID') PAYMENT_STATUS_FLAG , aia.invoice_date, aps.vendor_name, apss.vendor_site_code, aila.line_number, aia.invoice_amount, aila.amount line_amount, pha.segment1 po_number, aila.line_type_lookup_code, apt.name Term_name, gcc.concatenated_segments GL_Code, aca.check_number, aipa.amount payment_amount, apsa.amount_remaining from apps.ap_invoices_all aia, ap_invoice_lines_all aila, ap_invoice_distributions_all aida, ap_suppliers aps, ap_supplier_sites_all apss, po_headers_all pha, gl_code_combinations_kfv gcc, ap_invoice_payments_all aipa, ap_checks_all aca, ap_payment_schedules_all apsa, ap_terms apt, hr_operating_units hou, gl_ledgers gl where 1=1 and aia.invoice_id = aila.invoice_id and aila.invoice_id = aida.invoice_id and aila.line_number = aida.invoice_line_number and aia.vendor_id=aps.vendor_id --and aia.PAYMENT_STATUS_FLAG != ’Y’ and aia.VENDOR_SITE_ID=APSS.VENDOR_SITE_ID AND aps.vendor_id=apss.VENDOR_ID and aia.po_header_id=pha.po_header_id(+) and aida.dist_code_combination_id=gcc.code_combination_id and aipa.invoice_id(+)=aia.invoice_id and aca.check_id (+)=aipa.check_id and apsa.invoice_id=aia.invoice_id and apt.term_id=aia.terms_id and hou.organization_id=aia.org_id and gl.ledger_id=aia.set_of_books_id US XXAP_Supplier_Invoice_Listing List of invoices and payments for suppliers 1=1 1 10 1=1 aia.invoice_date>=:invoice_date_from Date 1-JAN-2020 Y US Inv. Date From 2 20 1=1 aps.vendor_name like '%'|| :supplier_name ||'%' Char 3M Health Care US Supplier