DBA Data[Home] [Help]

APPS.PA_PWP_NOTIFICATION dependencies on PA_EXPENDITURE_ITEMS

Line 465: ,pa_expenditure_items ei

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

Line 479: ,pa_expenditure_items ei

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