[Home] [Help] [Dependency Information]
Object Name: | PA_ADW_TOPTSK_ACT_CMT_V |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | PA.PA_ADW_TOPTSK_ACT_CMT_V |
Subobject Name: | |
Status: | VALID |
Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.
Internal
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
PROJECT_ID | NUMBER | (15) | Yes | project identifier |
TOP_TASK_ID | NUMBER | (15) | top task identifier | |
TASK_ID | NUMBER | (15) | lowest task identifier | |
PA_PERIOD_KEY | VARCHAR2 | (61) | PA period name concatenated with the set of books identifier | |
EXPENSE_ORGANIZATION_ID | NUMBER | expenditure organization identifier | ||
OWNER_ORGANIZATION_ID | NUMBER | task owning organization identifier | ||
RESOURCE_LIST_MEMBER_ID | NUMBER | (15) | Yes | resource list member identifier |
SERVICE_TYPE_CODE | VARCHAR2 | (30) | top task service type code | |
EXPENDITURE_TYPE | VARCHAR2 | (80) | expenditure type name | |
USER_COL1 | VARCHAR2 | (0) | column that can be used to include user customizations for additional dimensions; if you have not defined any customizations, this column has NULL value | |
USER_COL2 | VARCHAR2 | (0) | column that can be used to include user customizations for additional dimensions; if you have not defined any customizations, this column has NULL value | |
USER_COL3 | VARCHAR2 | (0) | column that can be used to include user customizations for additional dimensions; if you have not defined any customizations, this column has NULL value | |
USER_COL4 | VARCHAR2 | (0) | column that can be used to include user customizations for additional dimensions; if you have not defined any customizations, this column has NULL value | |
USER_COL5 | VARCHAR2 | (0) | column that can be used to include user customizations for additional dimensions; if you have not defined any customizations, this column has NULL value | |
USER_COL6 | VARCHAR2 | (0) | column that can be used to include user customizations for additional dimensions; if you have not defined any customizations, this column has NULL value | |
USER_COL7 | VARCHAR2 | (0) | column that can be used to include user customizations for additional dimensions; if you have not defined any customizations, this column has NULL value | |
USER_COL8 | VARCHAR2 | (0) | column that can be used to include user customizations for additional dimensions; if you have not defined any customizations, this column has NULL value | |
USER_COL9 | VARCHAR2 | (0) | column that can be used to include user customizations for additional dimensions; if you have not defined any customizations, this column has NULL value | |
USER_COL10 | VARCHAR2 | (0) | column that can be used to include user customizations for additional dimensions; if you have not defined any customizations, this column has NULL value | |
ACCUME_REVENUE | NUMBER | the actual accumulated revenue amount | ||
ACCUME_RAW_COST | NUMBER | the actual accumulated raw cost amount | ||
ACCUME_BURDENED_COST | NUMBER | the actual accumulated burdened cost amount | ||
ACCUME_QUANTITY | NUMBER | the actual accumulated quantity | ||
ACCUME_LABOR_HOURS | NUMBER | the actual accumulated labor hours | ||
ACCUME_BILLABLE_RAW_COST | NUMBER | the actual accumulated billable raw cost amount | ||
ACCUME_BILLABLE_BURDENED_COST | NUMBER | the actual accumulated billable burdened cost amount | ||
ACCUME_BILLABLE_QUANTITY | NUMBER | the actual accumulated billable quantity | ||
ACCUME_BILLABLE_LABOR_HOURS | NUMBER | the actual accumulated billable labor hours | ||
ACCUME_CMT_RAW_COST | NUMBER | the accumulated commitment raw cost amount | ||
ACCUME_CMT_BURDENED_COST | NUMBER | the accumulated commitment burdened cost amount | ||
ACCUME_CMT_QUANTITY | NUMBER | the accumulated commitment quantity | ||
UNIT_OF_MEASURE | VARCHAR2 | (30) | the unit of measure name for quantity | |
RES_ADW_NOTIFY_FLAG | VARCHAR2 | (1) | this column is used internally by Projects Analysis Collection Pack | |
TXN_ADW_NOTIFY_FLAG | VARCHAR2 | (1) | this column is used internally by Projects Analysis Collection Pack |
Cut, paste (and edit) the following text to query this object:
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
FROM APPS.PA_ADW_TOPTSK_ACT_CMT_V;
APPS.PA_ADW_TOPTSK_ACT_CMT_V is not referenced by any database object
|
|
|