eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

View: PA_STATUS_EI_BASE_V

Product:	PA - Projects
Description:	10SC Only
Implementation/DBA Data:	APPS.PA_STATUS_EI_BASE_V

View Text

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

Columns

Name
EXPENDITURE_ITEM_ID
PA_START_DATE
PA_PERIOD
QUANTITY
RAW_COST
BURDENED_COST
BILLABLE_QUANTITY
BILLABLE_RAW_COST
BILLABLE_BURDENED_COST
REVENUE
DENOM_RAW_COST
DENOM_BURDENED_COST
ACCT_RAW_COST
ACCT_BURDENED_COST