SELECT to_char(invoice_id)||'-'||to_char(org_id)|| '-'||substrb(edw_instance.get_code,1,40), last_update_date from ap_invoices_all ai WHERE invoice_type_lookup_code <> 'EXPENSE REPORT'
View Text - HTML Formatted
SELECT TO_CHAR(INVOICE_ID)||'-'||TO_CHAR(ORG_ID)|| '-'||SUBSTRB(EDW_INSTANCE.GET_CODE , 1 , 40) , LAST_UPDATE_DATE FROM AP_INVOICES_ALL AI WHERE INVOICE_TYPE_LOOKUP_CODE <> 'EXPENSE REPORT'