Project Invoice Query
This is an AP invoice query that we use to do a reconciliation between Payable, GL and Projects. The base of the query is a map from Payables to General Ledger through the XLA. It also pulls in project and vendor information. Select aia . invoice_num AS "Invoice Number" , REPLACE ( REPLACE ( aida . description , chr ( 10 ), '' ), chr ( 13 ), '' ) AS "Distribution Description" , aida . invoice_distribution_id , 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 || '.' || gcc . segment2 || '.' || gcc . segment3 || '.' || gcc . segment4 || '.' || gcc . segment5 || '.' || gcc . segment6 "GL Combination" , aida . PJC_EXPENDITURE_ITEM_DATE , aia . SOURCE AS "Invoice Source" , pett . EXPENDITURE_TYPE_NAME , prj . segment1 AS "Project...