ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN B9847D20A0E4742FE0538931640A6379 AP Supplier Y Y select aps.vendor_name value, aps.segment1 description from ap_suppliers aps where (:$flex$.operating_unit is null or aps.vendor_id in (select assa.vendor_id from hr_all_organization_units_vl haouv, ap_supplier_sites_all assa where xxen_util.contains(:$flex$.operating_unit,haouv.name)='Y' and haouv.organization_id=assa.org_id)) and (:$flex$.organization_code is null or aps.vendor_id in (select assa.vendor_id from org_organization_definitions ood, ap_supplier_sites_all assa where xxen_util.contains(:$flex$.organization_code,ood.organization_code)='Y' and ood.operating_unit=assa.org_id)) order by aps.vendor_name, aps.vendor_id US 8E2FF36EDF1479D2E0530100007F1FF2 AP Supplier Number Y select aps.segment1 value, aps.vendor_name description from ap_suppliers aps where :$flex$.operating_unit is null or aps.vendor_id in (select assa.vendor_id from hr_all_organization_units_vl haouv, ap_supplier_sites_all assa where xxen_util.contains(:$flex$.operating_unit,haouv.name)='Y' and haouv.organization_id=assa.org_id) order by aps.segment1, aps.vendor_id US 41DBE760E374CF9FE06362FB09056EA6Y select aps.segment1 vendor_number, aps.vendor_name, aia.* from ap_suppliers aps, ap_invoices aia where 1=1 and aps.vendor_id=aia.vendor_id :Supplier_Number is not null or :Supplier is not null or :invoice_date_to-:invoice_date_from<=530 or ( fnd_global.resp_name not in ('Receivables, Vision Germany','Receivables Vision France') and fnd_global.org_name<>'Vision Operations' ) US AP Suppliers and Invoices test A supplier or invoice date restriction up to 2 years is mandatory for operating unit 'Vision Operations' and responsibilities 'Receivables, Vision Germany' and 'Receivables Vision France' 1=1 1 10 1=1 aps.segment1=:supplier_number LOV AP Supplier Number 8E2FF36EDF1479D2E0530100007F1FF2 Y select aps.segment1 value, aps.vendor_name description from ap_suppliers aps where :$flex$.operating_unit is null or aps.vendor_id in (select assa.vendor_id from hr_all_organization_units_vl haouv, ap_supplier_sites_all assa where xxen_util.contains(:$flex$.operating_unit,haouv.name)='Y' and haouv.organization_id=assa.org_id) order by aps.segment1, aps.vendor_id US Supplier Number 2 20 1=1 aps.vendor_name=:vendor_name LOV AP Supplier B9847D20A0E4742FE0538931640A6379 Y Y select aps.vendor_name value, aps.segment1 description from ap_suppliers aps where (:$flex$.operating_unit is null or aps.vendor_id in (select assa.vendor_id from hr_all_organization_units_vl haouv, ap_supplier_sites_all assa where xxen_util.contains(:$flex$.operating_unit,haouv.name)='Y' and haouv.organization_id=assa.org_id)) and (:$flex$.organization_code is null or aps.vendor_id in (select assa.vendor_id from org_organization_definitions ood, ap_supplier_sites_all assa where xxen_util.contains(:$flex$.organization_code,ood.organization_code)='Y' and ood.operating_unit=assa.org_id)) order by aps.vendor_name, aps.vendor_id US Supplier 3 30 1=1 aia.invoice_date>=:invoice_date_from Date US Invoice Date From 4 40 1=1 aia.invoice_date<:invoice_date_to+1 Date last_day(:$flex$.Invoice_Date_From) US Invoice Date To 4372FEC12AD29A611AAEF902CFE3517E Main invoice columns only ANDY.HAACK 8 AMOUNT_PAID 7 INVOICE_AMOUNT 6 INVOICE_CURRENCY_CODE 5 INVOICE_DATE 4 INVOICE_NUM 2 INVOICE_TYPE_LOOKUP_CODE 1 SOURCE 3 VENDOR_NAME S Site 4372FEC12AD29A611AAEF902CFE3517E