[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
SELECT
PROJECT_ID,
ACCUM_PERIOD,
RAW_COST_ITD,
RAW_COST_YTD,
RAW_COST_PP,
RAW_COST_PTD,
BILLABLE_RAW_COST_ITD,
BILLABLE_RAW_COST_YTD,
BILLABLE_RAW_COST_PP,
BILLABLE_RAW_COST_PTD,
BURDENED_COST_ITD,
BURDENED_COST_YTD,
BURDENED_COST_PP,
BURDENED_COST_PTD,
BILLABLE_BURDENED_COST_ITD,
BILLABLE_BURDENED_COST_YTD,
BILLABLE_BURDENED_COST_PP,
BILLABLE_BURDENED_COST_PTD,
QUANTITY_ITD,
QUANTITY_YTD,
QUANTITY_PP,
QUANTITY_PTD,
LABOR_HOURS_ITD,
LABOR_HOURS_YTD,
LABOR_HOURS_PP,
LABOR_HOURS_PTD,
BILLABLE_QUANTITY_ITD,
BILLABLE_QUANTITY_YTD,
BILLABLE_QUANTITY_PP,
BILLABLE_QUANTITY_PTD,
BILLABLE_LABOR_HOURS_ITD,
BILLABLE_LABOR_HOURS_YTD,
BILLABLE_LABOR_HOURS_PP,
BILLABLE_LABOR_HOURS_PTD,
REVENUE_ITD,
REVENUE_YTD,
REVENUE_PP,
REVENUE_PTD,
CMT_RAW_COST_ITD,
CMT_RAW_COST_YTD,
CMT_RAW_COST_PP,
CMT_RAW_COST_PTD,
CMT_BURDENED_COST_ITD,
CMT_BURDENED_COST_YTD,
CMT_BURDENED_COST_PP,
CMT_BURDENED_COST_PTD,
CMT_QUANTITY_ITD,
CMT_QUANTITY_YTD,
CMT_QUANTITY_PP,
CMT_QUANTITY_PTD
FROM
PA_PROJECT_ACCUM_HEADERS PAH,
PA_PROJECT_ACCUM_ACTUALS PAA,
PA_PROJECT_ACCUM_COMMITMENTS PAC
WHERE
PAH.PROJECT_ACCUM_ID = PAA.PROJECT_ACCUM_ID(+)
AND PAH.PROJECT_ACCUM_ID = PAC.PROJECT_ACCUM_ID(+)
AND PAH.PROJECT_ACCUM_ID = X_PROJECT_ACCUM_ID;
SELECT
PROJECT_ID,
BUDGET_TYPE_CODE,
BASE_RAW_COST_ITD,
BASE_RAW_COST_YTD,
BASE_RAW_COST_PP,
BASE_RAW_COST_PTD,
BASE_BURDENED_COST_ITD,
BASE_BURDENED_COST_YTD,
BASE_BURDENED_COST_PP,
BASE_BURDENED_COST_PTD,
ORIG_RAW_COST_ITD,
ORIG_RAW_COST_YTD,
ORIG_RAW_COST_PP,
ORIG_RAW_COST_PTD,
ORIG_BURDENED_COST_ITD,
ORIG_BURDENED_COST_YTD,
ORIG_BURDENED_COST_PP,
ORIG_BURDENED_COST_PTD,
BASE_REVENUE_ITD,
BASE_REVENUE_YTD,
BASE_REVENUE_PP,
BASE_REVENUE_PTD,
ORIG_REVENUE_ITD,
ORIG_REVENUE_YTD,
ORIG_REVENUE_PP,
ORIG_REVENUE_PTD,
ORIG_LABOR_HOURS_ITD,
ORIG_LABOR_HOURS_YTD,
ORIG_LABOR_HOURS_PP,
ORIG_LABOR_HOURS_PTD,
BASE_LABOR_HOURS_ITD,
BASE_LABOR_HOURS_YTD,
BASE_LABOR_HOURS_PP,
BASE_LABOR_HOURS_PTD,
ORIG_QUANTITY_YTD,
ORIG_QUANTITY_ITD,
ORIG_QUANTITY_PP,
ORIG_QUANTITY_PTD,
BASE_QUANTITY_YTD,
BASE_QUANTITY_ITD,
BASE_QUANTITY_PP,
BASE_QUANTITY_PTD,
ORIG_LABOR_HOURS_TOT,
BASE_LABOR_HOURS_TOT,
ORIG_QUANTITY_TOT,
BASE_QUANTITY_TOT,
BASE_RAW_COST_TOT,
BASE_BURDENED_COST_TOT,
ORIG_RAW_COST_TOT,
ORIG_BURDENED_COST_TOT,
BASE_REVENUE_TOT,
ORIG_REVENUE_TOT
FROM
PA_PROJECT_ACCUM_HEADERS PAH,
PA_PROJECT_ACCUM_BUDGETS PAB
WHERE
PAH.PROJECT_ACCUM_ID = PAB.PROJECT_ACCUM_ID -- No outer Join
and pab.fin_plan_type_id is null
AND PAH.PROJECT_ACCUM_ID = X_PROJECT_ACCUM_ID;
SELECT
PROJECT_ID,
NVL(SUM(TOT_REVENUE),0) + NVL(SUM(I_TOT_REVENUE),0) TXN_REVENUE,
NVL(SUM(TOT_RAW_COST),0)+ NVL(SUM(I_TOT_RAW_COST),0) TXN_RAW_COST,
NVL(SUM(TOT_BURDENED_COST),0)+ NVL(SUM(I_TOT_BURDENED_COST),0) TXN_BURDENED_COST,
NVL(SUM(TOT_QUANTITY),0)+ NVL(SUM(I_TOT_QUANTITY),0) TXN_QUANTITY,
NVL(SUM(TOT_LABOR_HOURS),0) + NVL(SUM(I_TOT_LABOR_HOURS),0) TXN_LABOR_HOURS,
NVL(SUM(TOT_BILLABLE_RAW_COST),0)
+ NVL(SUM(I_TOT_BILLABLE_RAW_COST),0) TXN_BILLABLE_RAW_COST,
NVL(SUM(TOT_BILLABLE_BURDENED_COST),0)
+ NVL(SUM(I_TOT_BILLABLE_BURDENED_COST),0) TXN_BILLABLE_BURDENED_COST,
NVL(SUM(TOT_BILLABLE_QUANTITY),0)
+ NVL(SUM(I_TOT_BILLABLE_QUANTITY),0) TXN_BILLABLE_QUANTITY,
NVL(SUM(TOT_BILLABLE_LABOR_HOURS),0)
+ NVL(SUM(I_TOT_BILLABLE_LABOR_HOURS),0) TXN_BILLABLE_LABOR_HOURS
FROM
PA_TXN_ACCUM PTA
WHERE
PROJECT_ID = X_PROJECT_ID
AND exists
( SELECT 'Yes'
FROM pa_txn_accum_details ptad
WHERE pta.txn_accum_id = ptad.txn_accum_id
AND ptad.line_type IN ('C','R','E')
)
GROUP BY PROJECT_ID;