eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

DBA Data [Home] [Help] [Dependency Information]

VIEW: APPS.PA_TASK_PROGRESS_AMG_V

Object Details

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

View Type

A public view which may be useful for custom reporting or other data
requirements.

This view provides progress data for structure tasks

[View Source]

Columns

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

Query Text

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;

Dependencies

[top of page]

APPS.PA_TASK_PROGRESS_AMG_V references the following:

APPS: PA_PERCENT_COMPLETES; PA_PROGRESS_ROLLUP; PA_PROGRESS_UTILS - show dependent code; PA_PROJECT_STATUSES; PA_PROJ_ELEMENTS; PA_PROJ_ELEMENT_VERSIONS; PA_PROJ_ELEM_VER_STRUCTURE; PA_PROJ_STRUCTURE_TYPES; PA_STRUCTURE_TYPES; PA_TASK_TYPES; PJI_XBS_PLANS_V

APPS.PA_TASK_PROGRESS_AMG_V is referenced by following:

APPS: ENG_ATTACHMENT_IMPLEMENTATION - show dependent code