AP-SLA-GL QUERY with project and Purchase Order data
This query is very similar to my last. This query will show all the distributions that post from project invoices to GL. It also includes some PO data and project data as well. Select aia . invoice_num as "Invoice Number" , replace ( replace ( aida . description , chr ( 10 ), '' ), chr ( 13 ), '' ) as "Distribution Description" , NVL ( psv . vendor_name , ( SELECT PERSON_FIRST_NAME || ' ' || person_last_name from hz_parties hp where aia . party_id = hp . party_id ) ) as Supplier , gcc . segment1 "Company" , gcc . segment2 "Division" , gcc . segment3 "Department" , gcc . segment4 "Account" , gcc . segment5 "Fut1" , gcc . segment6 "Fut2" , aida . PJC_EXPENDITURE_ITEM_DATE , aia . SOURCE as "Invoice Source" , pett . EXPENDITURE_TYPE_NAME , prj . segment1 as "Project Number" , prj . name as "Project Name" , tsk .