[Home] [Help]
View: PA_ADW_R_ST_ACT_CMT_V
Product: | PA - Projects |
Description: | Values for actuals and commitments when the service types on tasks are changed |
Implementation/DBA Data: |
APPS.PA_ADW_R_ST_ACT_CMT_V
|
View Text
SELECT PROJECT_ID
, TOP_TASK_ID
, TASK_ID
, PA_PERIOD_KEY
, EXPENSE_ORGANIZATION_ID
, OWNER_ORGANIZATION_ID
, RESOURCE_LIST_MEMBER_ID
, SERVICE_TYPE_CODE
, EXPENDITURE_TYPE
, USER_COL1
, USER_COL2
, USER_COL3
, USER_COL4
, USER_COL5
, USER_COL6
, USER_COL7
, USER_COL8
, USER_COL9
, USER_COL10
, ACCUME_REVENUE
, ACCUME_RAW_COST
, ACCUME_BURDENED_COST
, ACCUME_QUANTITY
, ACCUME_LABOR_HOURS
, ACCUME_BILLABLE_RAW_COST
, ACCUME_BILLABLE_BURDENED_COST
, ACCUME_BILLABLE_QUANTITY
, ACCUME_BILLABLE_LABOR_HOURS
, ACCUME_CMT_RAW_COST
, ACCUME_CMT_BURDENED_COST
, ACCUME_CMT_QUANTITY
, UNIT_OF_MEASURE
, RES_ADW_NOTIFY_FLAG
, TXN_ADW_NOTIFY_FLAG
, TSK_ADW_NOTIFY_FLAG
FROM PA_ADW_R_ST_ACT_CMT_B_V
Columns
Name |
PROJECT_ID |
TOP_TASK_ID |
TASK_ID |
PA_PERIOD_KEY |
EXPENSE_ORGANIZATION_ID |
OWNER_ORGANIZATION_ID |
RESOURCE_LIST_MEMBER_ID |
SERVICE_TYPE_CODE |
EXPENDITURE_TYPE |
USER_COL1 |
USER_COL2 |
USER_COL3 |
USER_COL4 |
USER_COL5 |
USER_COL6 |
USER_COL7 |
USER_COL8 |
USER_COL9 |
USER_COL10 |
ACCUME_REVENUE |
ACCUME_RAW_COST |
ACCUME_BURDENED_COST |
ACCUME_QUANTITY |
ACCUME_LABOR_HOURS |
ACCUME_BILLABLE_RAW_COST |
ACCUME_BILLABLE_BURDENED_COST |
ACCUME_BILLABLE_QUANTITY |
ACCUME_BILLABLE_LABOR_HOURS |
ACCUME_CMT_RAW_COST |
ACCUME_CMT_BURDENED_COST |
ACCUME_CMT_QUANTITY |
UNIT_OF_MEASURE |
RES_ADW_NOTIFY_FLAG |
TXN_ADW_NOTIFY_FLAG |
TSK_ADW_NOTIFY_FLAG |