VIEW: APPS.PA_ADW_TOPTSK_ACT_CMT_V

Source

View Text - Preformatted

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

View Text - HTML Formatted

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