DBA Data[Home] [Help]

APPS.PA_PWP_NOTIFICATION dependencies on PA_DRAFT_INVOICE_ITEMS

Line 477: ,pa_draft_invoice_items pdii

473: SELECT DISTINCT ei.document_header_id Invoice_Id
474: ,ei.project_currency_code proj_currency_code
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