DBA Data[Home] [Help]

APPS.PA_BILLING_AMOUNT dependencies on PA_EXPENDITURE_ITEMS_ALL

Line 736: pa_expenditure_items_all ei,

732: /* Change this column from amount to projfunc_bill_amount for MCB2 */
733: SELECT sum(nvl(rdl.projfunc_bill_amount,0))
734: INTO task_billed_ccinv
735: FROM pa_cust_rev_dist_lines rdl,
736: pa_expenditure_items_all ei,
737: pa_tasks t
738: WHERE ei.task_id = t.task_id
739: AND ei.expenditure_item_id = rdl.expenditure_item_id
740: AND rdl.project_id = X2_project_id