VIEW: APPS.PA_PROJ_CCREV_COST_V

Source

View Text - Preformatted

SELECT ta.project_id PROJECT_ID, t.top_task_id TASK_ID, nvl(ta.tot_burdened_cost, nvl(ta.tot_raw_cost,0)) + nvl(ta.i_tot_burdened_cost, nvl(i_tot_raw_cost,0)) BURDENED_COST, pp.start_date pa_start_date, pp.end_date pa_end_date FROM pa_txn_accum ta, pa_tasks t, pa_periods pp WHERE ta.task_id = t.task_id AND pp.period_name = ta.pa_period UNION ALL SELECT t.project_id PROJECT_ID, t.top_task_id TASK_ID, (nvl((cdl.burdened_cost + nvl(project_burdened_change,0)), nvl(cdl.amount,0))) BURDENED_COST, pp.start_date pa_start_date, pp.end_date pa_end_date FROM pa_cost_distribution_lines_all cdl, pa_tasks t, pa_periods pp WHERE cdl.project_id = t.project_id AND cdl.task_id = t.task_id AND cdl.pa_date between pp.start_date and pp.end_date AND cdl.resource_accumulated_flag = 'N' AND cdl.line_type = 'R'

View Text - HTML Formatted

SELECT TA.PROJECT_ID PROJECT_ID
, T.TOP_TASK_ID TASK_ID
, NVL(TA.TOT_BURDENED_COST
, NVL(TA.TOT_RAW_COST
, 0)) + NVL(TA.I_TOT_BURDENED_COST
, NVL(I_TOT_RAW_COST
, 0)) BURDENED_COST
, PP.START_DATE PA_START_DATE
, PP.END_DATE PA_END_DATE
FROM PA_TXN_ACCUM TA
, PA_TASKS T
, PA_PERIODS PP
WHERE TA.TASK_ID = T.TASK_ID
AND PP.PERIOD_NAME = TA.PA_PERIOD UNION ALL SELECT T.PROJECT_ID PROJECT_ID
, T.TOP_TASK_ID TASK_ID
, (NVL((CDL.BURDENED_COST + NVL(PROJECT_BURDENED_CHANGE
, 0))
, NVL(CDL.AMOUNT
, 0))) BURDENED_COST
, PP.START_DATE PA_START_DATE
, PP.END_DATE PA_END_DATE
FROM PA_COST_DISTRIBUTION_LINES_ALL CDL
, PA_TASKS T
, PA_PERIODS PP
WHERE CDL.PROJECT_ID = T.PROJECT_ID
AND CDL.TASK_ID = T.TASK_ID
AND CDL.PA_DATE BETWEEN PP.START_DATE
AND PP.END_DATE
AND CDL.RESOURCE_ACCUMULATED_FLAG = 'N'
AND CDL.LINE_TYPE = 'R'