[Home] [Help] [Dependency Information]
Object Name: | PA_TASK_PROGRESS_V |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | PA.PA_TASK_PROGRESS_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_NAME | VARCHAR2 | (30) | Yes | |
PROJECT_NUMBER | VARCHAR2 | (25) | Yes | |
LONG_NAME | VARCHAR2 | (240) | ||
TASK_ID | NUMBER | (15) | Yes | |
PROJ_ELEMENT_ID | NUMBER | (15) | Yes | |
ELEMENT_VERSION_ID | NUMBER | (15) | Yes | |
OBJECT_TYPE | VARCHAR2 | (30) | Yes | |
TASK_NAME | VARCHAR2 | (240) | Yes | |
TASK_NUMBER | VARCHAR2 | (100) | ||
WBS_NUMBER | VARCHAR2 | (240) | ||
WBS_LEVEL | NUMBER | (3) | ||
TASK_MANAGER_PERSON_ID | NUMBER | (15) | ||
TASK_MANAGER_NAME | VARCHAR2 | (0) | ||
ORGANIZATION_ID | NUMBER | (15) | ||
DISPLAY_SEQUENCE | NUMBER | (15) | Identifies the display order of the task version within a structure version. This is a task-specific attribute. | |
MILESTONE_FLAG | VARCHAR2 | (1) | ||
CRITICAL_FLAG | VARCHAR2 | (1) | ||
SUMMARY_ELEMENT_FLAG | VARCHAR2 | (0) | ||
PRIORITY_CODE | VARCHAR2 | (30) | ||
PRIORITY_DESCRIPTION | VARCHAR2 | (80) | ||
PRIORITY_SORT | VARCHAR2 | (150) | ||
STATUS_CODE | VARCHAR2 | (150) | ||
STATUS_DESCRIPTION | VARCHAR2 | (80) | Yes | |
SYSTEM_TASK_STATUS_CODE | VARCHAR2 | (30) | Yes | |
PLANNED_EFFORT | NUMBER | (17) | ||
PLANNED_WORK_QUANTITY | NUMBER | (17) | ||
WORK_ITEM_CODE | VARCHAR2 | (30) | ||
WORK_ITEM_DESCRIPTION | VARCHAR2 | (80) | ||
UOM_CODE | VARCHAR2 | (30) | ||
UOM_DESCRIPTION | VARCHAR2 | (80) | ||
AS_OF_DATE | DATE | |||
PERCENT_COMPLETE_ID | NUMBER | (15) | ||
COMPLETED_PERCENTAGE | NUMBER | (7) | ||
PROGRESS_STATUS_CODE | VARCHAR2 | (30) | ||
PROGRESS_STATUS_DESC | VARCHAR2 | (80) | ||
SYSTEM_PROGRESS_STAT_CODE | VARCHAR2 | (30) | ||
PROGRESS_STATUS_WEIGHT | NUMBER | (15) | ||
STATUS_ICON_IND | VARCHAR2 | (80) | ||
STATUS_ICON_ACTIVE_IND | VARCHAR2 | (80) | ||
BASELINE_START_DATE | DATE | |||
BASELINE_FINISH_DATE | DATE | |||
SCHEDULED_START_DATE | DATE | |||
SCHEDULED_FINISH_DATE | DATE | |||
ACTUAL_START_DATE | DATE | |||
ACTUAL_FINISH_DATE | DATE | |||
ESTIMATED_START_DATE | DATE | |||
ESTIMATED_FINISH_DATE | DATE | |||
INCREMENTAL_WORK_QTY | NUMBER | (17) | ||
CUMULATIVE_WORK_QTY | NUMBER | (17) | ||
BASE_PERCENT_COMPLETE | NUMBER | (17) | ||
EFF_ROLLUP_PERCENT_COMP | NUMBER | (17) | ||
PUBLISHED_BY_PARTY_ID | NUMBER | (15) | ||
PUBLISHED_BY_NAME | VARCHAR2 | (0) | ||
PROGRESS_COMMENT | VARCHAR2 | (4000) | ||
PROGRESS_OVERVIEW | VARCHAR2 | (250) | ||
LAST_UPDATED_DATE | DATE | |||
PUBLISHED_FLAG | VARCHAR2 | (1) | ||
CURRENT_FLAG | VARCHAR2 | (1) | ||
PROCESS_STATUS_NAME | VARCHAR2 | (4000) | ||
PROCESS_STATUS_CODE | VARCHAR2 | (25) | ||
RECORD_VERSION_NUMBER | NUMBER | |||
EST_SCH_START_VAR | NUMBER | |||
EST_SCH_FINISH_VAR | NUMBER | |||
ACT_SCH_START_VAR | NUMBER | |||
ACT_SCH_FINISH_VAR | NUMBER | |||
SCH_BASE_START_VAR | NUMBER | |||
SCH_BASE_FINISH_VAR | NUMBER | |||
BASE_PROGRESS_STATUS_CODE | VARCHAR2 | (150) | ||
EFF_ROLLUP_PROG_STAT_CODE | VARCHAR2 | (150) | ||
PROG_ENTRY_ENABLE_FLAG | VARCHAR2 | (1) | ||
PROG_ENTRY_REQ_FLAG | VARCHAR2 | (1) | ||
ELEM_ROW_ID | ROWID | (10) | ||
NEXT_PROGRESS_DUE_DATE | DATE | |||
OPEN_ISSUES | NUMBER | |||
OPEN_CHANGE_DOCUMENTS | NUMBER | |||
DAYS_UNTIL_SCHEDULED_FINISH | NUMBER | The period in days left for scheduled finish of the task. | ||
TASK_TYPE | VARCHAR2 | (150) | The task type. | |
OPEN_CHANGE_REQUESTS | NUMBER | |||
OPEN_CHANGE_ORDERS | NUMBER | |||
PHASE | VARCHAR2 | (4000) | ||
ACTUAL_COST | NUMBER | |||
ACTUAL_EFFORT | NUMBER | |||
ACTUAL_EQUIP_EFFORT | NUMBER | |||
ACTUAL_PEOPLE_EFFORT | NUMBER | |||
ETC_COST | NUMBER | |||
ETC_EFFORT | NUMBER | |||
ETC_EQUIP_EFFORT | NUMBER | |||
EST_REMAINING_EFFORT | NUMBER | (17) | ||
CONSTRAINT_DATE | DATE | |||
CONSTRAINT_TYPE | VARCHAR2 | (4000) | ||
STRUCTURE_VERSION_ID | NUMBER | (15) | ||
PROJECT_CURRENCY_CODE | VARCHAR2 | (15) | Yes | |
PROJFUNC_CURRENCY_CODE | VARCHAR2 | (15) |
Cut, paste (and edit) the following text to query this object:
SELECT PROJECT_ID
, PROJECT_NAME
, PROJECT_NUMBER
, LONG_NAME
, TASK_ID
, PROJ_ELEMENT_ID
, ELEMENT_VERSION_ID
, OBJECT_TYPE
, TASK_NAME
, TASK_NUMBER
, WBS_NUMBER
, WBS_LEVEL
, TASK_MANAGER_PERSON_ID
, TASK_MANAGER_NAME
, ORGANIZATION_ID
, DISPLAY_SEQUENCE
, MILESTONE_FLAG
, CRITICAL_FLAG
, SUMMARY_ELEMENT_FLAG
, PRIORITY_CODE
, PRIORITY_DESCRIPTION
, PRIORITY_SORT
, STATUS_CODE
, STATUS_DESCRIPTION
, SYSTEM_TASK_STATUS_CODE
, PLANNED_EFFORT
, PLANNED_WORK_QUANTITY
, WORK_ITEM_CODE
, WORK_ITEM_DESCRIPTION
, UOM_CODE
, UOM_DESCRIPTION
, AS_OF_DATE
, PERCENT_COMPLETE_ID
, COMPLETED_PERCENTAGE
, PROGRESS_STATUS_CODE
, PROGRESS_STATUS_DESC
, SYSTEM_PROGRESS_STAT_CODE
, PROGRESS_STATUS_WEIGHT
, STATUS_ICON_IND
, STATUS_ICON_ACTIVE_IND
, BASELINE_START_DATE
, BASELINE_FINISH_DATE
, SCHEDULED_START_DATE
, SCHEDULED_FINISH_DATE
, ACTUAL_START_DATE
, ACTUAL_FINISH_DATE
, ESTIMATED_START_DATE
, ESTIMATED_FINISH_DATE
, INCREMENTAL_WORK_QTY
, CUMULATIVE_WORK_QTY
, BASE_PERCENT_COMPLETE
, EFF_ROLLUP_PERCENT_COMP
, PUBLISHED_BY_PARTY_ID
, PUBLISHED_BY_NAME
, PROGRESS_COMMENT
, PROGRESS_OVERVIEW
, LAST_UPDATED_DATE
, PUBLISHED_FLAG
, CURRENT_FLAG
, PROCESS_STATUS_NAME
, PROCESS_STATUS_CODE
, RECORD_VERSION_NUMBER
, EST_SCH_START_VAR
, EST_SCH_FINISH_VAR
, ACT_SCH_START_VAR
, ACT_SCH_FINISH_VAR
, SCH_BASE_START_VAR
, SCH_BASE_FINISH_VAR
, BASE_PROGRESS_STATUS_CODE
, EFF_ROLLUP_PROG_STAT_CODE
, PROG_ENTRY_ENABLE_FLAG
, PROG_ENTRY_REQ_FLAG
, ELEM_ROW_ID
, NEXT_PROGRESS_DUE_DATE
, OPEN_ISSUES
, OPEN_CHANGE_DOCUMENTS
, DAYS_UNTIL_SCHEDULED_FINISH
, TASK_TYPE
, OPEN_CHANGE_REQUESTS
, OPEN_CHANGE_ORDERS
, PHASE
, ACTUAL_COST
, ACTUAL_EFFORT
, ACTUAL_EQUIP_EFFORT
, ACTUAL_PEOPLE_EFFORT
, ETC_COST
, ETC_EFFORT
, ETC_EQUIP_EFFORT
, EST_REMAINING_EFFORT
, CONSTRAINT_DATE
, CONSTRAINT_TYPE
, STRUCTURE_VERSION_ID
, PROJECT_CURRENCY_CODE
, PROJFUNC_CURRENCY_CODE
FROM APPS.PA_TASK_PROGRESS_V;
APPS.PA_TASK_PROGRESS_V is not referenced by any database object
|
|
|