[Home] [Help] [Dependency Information]
Object Name: | PA_TASK_PROGRESS_AMG_V |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | PA.PA_TASK_PROGRESS_AMG_V |
Subobject Name: | |
Status: | VALID |
A public view which may be useful for custom reporting or other data
requirements.
This view provides progress data for structure tasks
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
PROJECT_ID | NUMBER | (15) | Yes | Unique identifier of the project to which the tasks belong |
TASK_ID | NUMBER | (15) | Yes | Unique identifier for the task |
TASK_VERSION_ID | NUMBER | (15) | Yes | Unique identifier for the task version |
TASK_NAME | VARCHAR2 | (240) | Yes | User-defined task name |
TASK_NUMBER | VARCHAR2 | (100) | User-defined task number | |
AS_OF_DATE | DATE | Task progress as-of-date | ||
COMPLETED_PERCENTAGE | NUMBER | Percentage completed of the task | ||
TASK_STATUS_CODE | VARCHAR2 | (150) | Status of the task | |
TASK_STATUS_DESC | VARCHAR2 | (80) | Yes | Task status description |
PROGRESS_STATUS_CODE | VARCHAR2 | (30) | Progress status of the task | |
PROGRESS_STATUS_DESC | VARCHAR2 | (80) | Progress status description | |
ACTUAL_START_DATE | DATE | Actual start date of the task | ||
ACTUAL_FINISH_DATE | DATE | Actual finish date of the task | ||
ESTIMATED_START_DATE | DATE | Estimated start date of the task | ||
ESTIMATED_FINISH_DATE | DATE | Estimated finish date of the task | ||
CUMULATIVE_WORK_QTY | NUMBER | (17) | Cumulative work quantity | |
EST_REMAINING_EFFORT | NUMBER | Estimated remaining effort | ||
PUBLISHED_BY_PARTY_ID | NUMBER | (15) | Unique identifier of the person reporting progress | |
PROGRESS_COMMENT | VARCHAR2 | (4000) | Progress comments | |
PROGRESS_OVERVIEW | VARCHAR2 | (250) | Progress overview | |
PROGRESS_ENTRY_ENABLED | VARCHAR2 | (1) | Indicates whether progress entry is enabled on the task type level | |
OBJECT_ID | NUMBER | (15) | Unique identifier for the object | |
OBJECT_VERSION_ID | NUMBER | (15) | Unique identifier for the object version | |
STRUCTURE_TYPE_CLASS_CODE | VARCHAR2 | (30) | Yes | Type class code of the structure, such as FINANCIAL or WORKPLAN |
ACTUAL_COST | NUMBER | Actual Cost | ||
ACTUAL_EFFORT | NUMBER | Actual Effort to Date | ||
ESTIMATE_AT_COMPLETION_COST | NUMBER | Estimated to Completion Cost | ||
PLANNED_EFFORT | NUMBER | Planned Effort to Date |
Cut, paste (and edit) the following text to query this object:
SELECT PROJECT_ID
, TASK_ID
, TASK_VERSION_ID
, TASK_NAME
, TASK_NUMBER
, AS_OF_DATE
, COMPLETED_PERCENTAGE
, TASK_STATUS_CODE
, TASK_STATUS_DESC
, PROGRESS_STATUS_CODE
, PROGRESS_STATUS_DESC
, ACTUAL_START_DATE
, ACTUAL_FINISH_DATE
, ESTIMATED_START_DATE
, ESTIMATED_FINISH_DATE
, CUMULATIVE_WORK_QTY
, EST_REMAINING_EFFORT
, PUBLISHED_BY_PARTY_ID
, PROGRESS_COMMENT
, PROGRESS_OVERVIEW
, PROGRESS_ENTRY_ENABLED
, OBJECT_ID
, OBJECT_VERSION_ID
, STRUCTURE_TYPE_CLASS_CODE
, ACTUAL_COST
, ACTUAL_EFFORT
, ESTIMATE_AT_COMPLETION_COST
, PLANNED_EFFORT
FROM APPS.PA_TASK_PROGRESS_AMG_V;
|
|
|