VIEW: APPS.PA_STATUS_EI_BASE_V

Source

View Text - Preformatted

SELECT EXPENDITURE_ITEM_ID ,PA_START_DATE ,PA_PERIOD , SUM(QUANTITY) , SUM(RAW_COST) , SUM(BURDENED_COST) , SUM(BILLABLE_QUANTITY) , SUM(BILLABLE_RAW_COST) , SUM(BILLABLE_BURDENED_COST) , SUM(REVENUE) , sum(denom_raw_cost) , sum(denom_burdened_cost) , sum(acct_raw_cost) , sum(acct_burdened_cost) FROM PA_STATUS_TASK_EI_BASE_V GROUP BY EXPENDITURE_ITEM_ID, PA_START_DATE,PA_PERIOD UNION ALL SELECT EXPENDITURE_ITEM_ID ,PA_START_DATE ,PA_PERIOD ,SUM(QUANTITY) ,SUM(RAW_COST) ,SUM(BURDENED_COST) ,SUM(BILLABLE_QUANTITY) ,SUM(BILLABLE_RAW_COST) ,SUM(BILLABLE_BURDENED_COST) ,SUM(REVENUE) ,sum(denom_raw_cost) ,sum(denom_burdened_cost) ,sum(acct_raw_cost) ,sum(acct_burdened_cost) FROM PA_STATUS_RSRC_EI_BASE_V GROUP BY EXPENDITURE_ITEM_ID,PA_START_DATE,PA_PERIOD

View Text - HTML Formatted

SELECT EXPENDITURE_ITEM_ID
, PA_START_DATE
, PA_PERIOD
, SUM(QUANTITY)
, SUM(RAW_COST)
, SUM(BURDENED_COST)
, SUM(BILLABLE_QUANTITY)
, SUM(BILLABLE_RAW_COST)
, SUM(BILLABLE_BURDENED_COST)
, SUM(REVENUE)
, SUM(DENOM_RAW_COST)
, SUM(DENOM_BURDENED_COST)
, SUM(ACCT_RAW_COST)
, SUM(ACCT_BURDENED_COST)
FROM PA_STATUS_TASK_EI_BASE_V GROUP BY EXPENDITURE_ITEM_ID
, PA_START_DATE
, PA_PERIOD UNION ALL SELECT EXPENDITURE_ITEM_ID
, PA_START_DATE
, PA_PERIOD
, SUM(QUANTITY)
, SUM(RAW_COST)
, SUM(BURDENED_COST)
, SUM(BILLABLE_QUANTITY)
, SUM(BILLABLE_RAW_COST)
, SUM(BILLABLE_BURDENED_COST)
, SUM(REVENUE)
, SUM(DENOM_RAW_COST)
, SUM(DENOM_BURDENED_COST)
, SUM(ACCT_RAW_COST)
, SUM(ACCT_BURDENED_COST)
FROM PA_STATUS_RSRC_EI_BASE_V GROUP BY EXPENDITURE_ITEM_ID
, PA_START_DATE
, PA_PERIOD