Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture
Comments
-
select s.vendor_name, i.invoice_num, i.invoice_date, L.amount amt, P.segment1 , E.Name ,T.EXPENDITURE_TYPE_NAME from AP_INVOICE_DISTRIBUTIONS_ALL L, AP_INVOICES_ALL I, POZ_SUPPLIERS_V S, PJF_EXP_TYPES_TL T, PJF_PROJECTS_ALL_B P, PJF_PROJ_ELEMENTS_TL E where i.invoice_id = l.Invoice_id and s.vendor_id = i.vendor_id and…