ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN FC6E0A3ED07F8032E05362FB090575C0Y Select * from ap_invoices_all where 1 =1 US RNK ABC 1=1 1 10 1=1 1=1 LOV Oracle AP_SRS_INVOICE_NUMBER_3DEP Y Y select invoice_id id, invoice_num value, null description from ap_invoices where org_id=nvl(:$flex$.fnd_mo_ou:null,org_id) and nvl(batch_id,-1)= nvl(:$flex$.ap_srs_batch_name:null,nvl(batch_id,-1)) and vendor_id=nvl(:$flex$.ap_srs_vendor_name_1dep:null, vendor_id) and invoice_type_lookup_code not in ('INVOICE REQUEST') and nvl(pay_group_lookup_code,'-1')= nvl(:$flex$.ap_srs_paygroup_2dep:null, nvl(pay_group_lookup_code,'-1')) and invoice_date>= nvl(decode(:$flex$.ap_srs_batch_name:null,null, to_date(:$flex$.ap_srs_invoice_start_date:null)), invoice_date) and invoice_date<= nvl(decode(:$flex$.ap_srs_batch_name:null,null, to_date(:$flex$.ap_srs_invoice_end_date:null)), invoice_date) order by invoice_num ERS-9163-109073 ERS-9163-109073 US Invoice Number Invoice id