View: PA_ADW_TOPTSK_ACT_CMT_V

Product:	PA - Projects
Description:	PA_ADW_TOPTSK_ACT_CMT_V view selects actual cost and revenue transaction amounts as well as commitments.
Implementation/DBA Data:	APPS.PA_ADW_TOPTSK_ACT_CMT_V

View Text

SELECT FACT.PROJECT_ID
, FACT.TOP_TASK_ID
, FACT.TASK_ID
, FACT.PA_PERIOD_KEY
, FACT.EXPENSE_ORGANIZATION_ID
, FACT.OWNER_ORGANIZATION_ID
, FACT.RESOURCE_LIST_MEMBER_ID
, FACT.SERVICE_TYPE_CODE
, FACT.EXPENDITURE_TYPE
, FACT.USER_COL1
, FACT.USER_COL2
, FACT.USER_COL3
, FACT.USER_COL4
, FACT.USER_COL5
, FACT.USER_COL6
, FACT.USER_COL7
, FACT.USER_COL8
, FACT.USER_COL9
, FACT.USER_COL10
, FACT.ACCUME_REVENUE
, FACT.ACCUME_RAW_COST
, FACT.ACCUME_BURDENED_COST
, FACT.ACCUME_QUANTITY
, FACT.ACCUME_LABOR_HOURS
, FACT.ACCUME_BILLABLE_RAW_COST
, FACT.ACCUME_BILLABLE_BURDENED_COST
, FACT.ACCUME_BILLABLE_QUANTITY
, FACT.ACCUME_BILLABLE_LABOR_HOURS
, FACT.ACCUME_CMT_RAW_COST
, FACT.ACCUME_CMT_BURDENED_COST
, FACT.ACCUME_CMT_QUANTITY
, FACT.UNIT_OF_MEASURE
, FACT.RES_ADW_NOTIFY_FLAG
, FACT.TXN_ADW_NOTIFY_FLAG
FROM PA_ADW_ACT_CMT_B_V FACT
, PA_ADW_TOP_TASKS_V TASK
WHERE FACT.TASK_ID = TASK.TOP_TASK_ID

Columns