[Home] [Help] [Dependency Information]
Object Name: | PA_CURR_PROJ_TASK_PROG_V |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | PA.PA_CURR_PROJ_TASK_PROG_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 | The identifier of project for which the percent complete information is entered |
PERCENT_COMPLETE_ID | NUMBER | (15) | Percent_complete_id generated in sequence from pa_percent_completes_s | |
TASK_ID | NUMBER | (15) | Yes | The identifier of the lowest level task for which the work is estimated by the percent completion |
PROJ_ELEMENT_ID | NUMBER | (15) | ||
ELEMENT_VERSION_ID | NUMBER | (15) | ||
OBJECT_TYPE | VARCHAR2 | (30) | ||
PROGRESS_STATUS_CODE | VARCHAR2 | (30) | Yes | |
PROGRESS_STATUS_NAME | VARCHAR2 | (80) | Yes | |
STATUS_ICON_IND | VARCHAR2 | (80) | ||
STATUS_ICON_ACTIVE_IND | VARCHAR2 | (80) | ||
AS_OF_DATE | DATE | Yes | ||
ACTUAL_START_DATE | DATE | |||
ACTUAL_FINISH_DATE | DATE | |||
ESTIMATED_START_DATE | DATE | |||
ESTIMATED_FINISH_DATE | DATE | |||
COMPLETED_PERCENTAGE | NUMBER | (7) | ||
BASE_PERCENT_COMPLETE | NUMBER | (17) | ||
INCREMENTAL_WORK_QTY | NUMBER | (17) | ||
CUMULATIVE_WORK_QTY | NUMBER | (17) | ||
ESTIMATED_REMAINING_EFFORT | NUMBER | (17) | ||
LAST_UPDATED_DATE | DATE | Yes | ||
PUBLISHED_BY_PARTY_ID | NUMBER | (15) | ||
PUBLISHED_BY_NAME | VARCHAR2 | (360) | ||
PROGRESS_COMMENT | VARCHAR2 | (4000) | ||
PROGRESS_OVERVIEW | VARCHAR2 | (250) | ||
PUBLISHED_FLAG | VARCHAR2 | (1) | ||
CURRENT_FLAG | VARCHAR2 | (1) | Yes | |
RECORD_VERSION_NUMBER | NUMBER |
Cut, paste (and edit) the following text to query this object:
SELECT PROJECT_ID
, PERCENT_COMPLETE_ID
, TASK_ID
, PROJ_ELEMENT_ID
, ELEMENT_VERSION_ID
, OBJECT_TYPE
, PROGRESS_STATUS_CODE
, PROGRESS_STATUS_NAME
, STATUS_ICON_IND
, STATUS_ICON_ACTIVE_IND
, AS_OF_DATE
, ACTUAL_START_DATE
, ACTUAL_FINISH_DATE
, ESTIMATED_START_DATE
, ESTIMATED_FINISH_DATE
, COMPLETED_PERCENTAGE
, BASE_PERCENT_COMPLETE
, INCREMENTAL_WORK_QTY
, CUMULATIVE_WORK_QTY
, ESTIMATED_REMAINING_EFFORT
, LAST_UPDATED_DATE
, PUBLISHED_BY_PARTY_ID
, PUBLISHED_BY_NAME
, PROGRESS_COMMENT
, PROGRESS_OVERVIEW
, PUBLISHED_FLAG
, CURRENT_FLAG
, RECORD_VERSION_NUMBER
FROM APPS.PA_CURR_PROJ_TASK_PROG_V;
APPS.PA_CURR_PROJ_TASK_PROG_V is not referenced by any database object
|
|
|