AP Invoice and PA Exp Details

select distinct pei.EXPENDITURE_ITEM_ID, pei.EXPENDITURE_ID,pei.TASK_ID,pei.project_id,ppa.segment1 PROJECT_NUMBER,ppa.name Project_name,
pei.EXPENDITURE_TYPE,pei.QUANTITY,RAW_COST,PEI.ATTRIBUTE1,TRANSACTION_SOURCE,PEI.ORG_ID,pea.ORIG_EXP_TXN_REFERENCE1 INVOICE_ID,
aih.invoice_num,poh.segment1 PO_NUMBER,PA_PERIOD_NAME
from apps.pa_expenditure_items_all pei,
apps.pa_expenditures_all pea,
apps.pa_projects_all ppa,
apps.AP_INVOICE_DISTRIBUTIONS_ALL aid,
apps.ap_invoices_all aih,
apps.po_distributions_all pd,
apps.po_headers_all poh,
apps.PA_COST_DIST_LINES_V pcdl
where pei.org_id = 170 --IN (171,170)
AND ppa.project_id = pei.project_id
AND pei.expenditure_id = pea.expenditure_id
AND pei.org_id = pea.org_id
and aid.po_distribution_id = pd.po_distribution_id
and pd.po_header_id = poh.po_header_id
and aid.invoice_id = pea.ORIG_EXP_TXN_REFERENCE1
AND aid.invoice_id = aih.INVOICE_ID
AND pcdl.EXPENDITURE_ITEM_ID = pei.EXPENDITURE_ITEM_ID
AND pei.org_id = pcdl.org_id
and TRANSACTION_SOURCE = 'AP INVOICE'
AND pcdl.pa_period_name = 'OCT-08'
--and aih.invoice_num = 'UI901156'
--and expenditure_item_id = 687492