[Home] [Help] [Dependency Information]
Object Name: | PA_TASK_PROG_HIST_V |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | PA.PA_TASK_PROG_HIST_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) | ||
PROJECT_NAME | VARCHAR2 | (30) | ||
PROJECT_NUMBER | VARCHAR2 | (25) | ||
TASK_ID | NUMBER | (15) | ||
PROJ_ELEMENT_ID | NUMBER | (15) | ||
ELEMENT_VERSION_ID | NUMBER | (15) | ||
OBJECT_TYPE | VARCHAR2 | (30) | ||
TASK_NAME | VARCHAR2 | (240) | ||
TASK_NUMBER | VARCHAR2 | (100) | ||
WBS_NUMBER | VARCHAR2 | (240) | ||
WBS_LEVEL | NUMBER | (3) | ||
TASK_MANAGER_PERSON_ID | NUMBER | (15) | ||
TASK_MANAGER_NAME | VARCHAR2 | (240) | ||
MILESTONE_FLAG | VARCHAR2 | (1) | ||
CRITICAL_FLAG | VARCHAR2 | (1) | ||
SUMMARY_ELEMENT_FLAG | VARCHAR2 | (4000) | ||
STATUS_CODE | VARCHAR2 | (150) | ||
STATUS_DESCRIPTION | VARCHAR2 | (80) | ||
PLANNED_EFFORT | NUMBER | (17) | ||
PLANNED_WORK_QUANTITY | NUMBER | (17) | ||
WORK_ITEM_CODE | VARCHAR2 | (30) | ||
WORK_ITEM_DESCRIPTION | CHAR | (0) | ||
UOM_CODE | VARCHAR2 | (30) | ||
UOM_DESCRIPTION | CHAR | (0) | ||
AS_OF_DATE | DATE | |||
PERCENT_COMPLETE_ID | NUMBER | (15) | ||
COMPLETED_PERCENTAGE | NUMBER | |||
PROGRESS_STATUS_CODE | VARCHAR2 | (30) | ||
PROGRESS_STATUS_DESC | VARCHAR2 | (80) | ||
STATUS_ICON_IND | VARCHAR2 | (80) | ||
STATUS_ICON_ACTIVE_IND | VARCHAR2 | (80) | ||
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 | |||
EFF_ROLLUP_PERCENT_COMP | NUMBER | |||
EST_REMAINING_EFFORT | NUMBER | (17) | ||
PUBLISHED_BY_PARTY_ID | NUMBER | (15) | ||
PUBLISHED_BY_NAME | VARCHAR2 | (360) | ||
PROGRESS_COMMENT | VARCHAR2 | (4000) | ||
PROGRESS_OVERVIEW | VARCHAR2 | (250) | ||
LAST_UPDATED_DATE | DATE | |||
PUBLISHED_FLAG | VARCHAR2 | (1) | ||
CURRENT_FLAG | VARCHAR2 | (1) | ||
RECORD_VERSION_NUMBER | NUMBER |
Cut, paste (and edit) the following text to query this object:
SELECT PROJECT_ID
, PROJECT_NAME
, PROJECT_NUMBER
, 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
, MILESTONE_FLAG
, CRITICAL_FLAG
, SUMMARY_ELEMENT_FLAG
, STATUS_CODE
, STATUS_DESCRIPTION
, 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
, STATUS_ICON_IND
, STATUS_ICON_ACTIVE_IND
, 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
, EST_REMAINING_EFFORT
, PUBLISHED_BY_PARTY_ID
, PUBLISHED_BY_NAME
, PROGRESS_COMMENT
, PROGRESS_OVERVIEW
, LAST_UPDATED_DATE
, PUBLISHED_FLAG
, CURRENT_FLAG
, RECORD_VERSION_NUMBER
FROM APPS.PA_TASK_PROG_HIST_V;
APPS.PA_TASK_PROG_HIST_V is not referenced by any database object
|
|
|