461: SELECT ap_invoice_id Invoice_id
462: ,ei.project_currency_code proj_currency_code
463: ,SUM(ei.raw_cost) Invoice_Amount
464: FROM pa_pwp_linked_invoices pwp
465: ,pa_expenditure_items ei
466: WHERE pwp.ap_invoice_id = ei.document_header_id
467: AND pwp.project_id = ei.project_id
468: AND pwp.project_id = l_project_id
469: AND pwp.draft_invoice_num = l_draft_inv_num
475: ,SUM(ei.raw_cost) Invoice_Amount
476: FROM pa_draft_invoices pdi
477: ,pa_draft_invoice_items pdii
478: ,pa_cust_rev_dist_lines crdl
479: ,pa_expenditure_items ei
480: WHERE pdi.project_id = pdii.project_id
481: AND pdi.draft_invoice_num = pdii.draft_invoice_num
482: AND pdii.project_id = crdl.project_id
483: AND pdii.draft_invoice_num = crdl.draft_invoice_num