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_STRUCT_PUB_TASK_VERS_V

Object Details

Object Name:	PA_STRUCT_PUB_TASK_VERS_V
Object Type:	VIEW
Owner:	APPS
FND Design Data:	PA.PA_STRUCT_PUB_TASK_VERS_V
Subobject Name:
Status:	VALID

* Warning: Oracle Internal Use Only *

Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.

View Type

Internal

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
PROJECT_ID	NUMBER		Yes	The identifier of the project to which the structure version or task version belongs
PROJ_ELEMENT_ID	NUMBER	(15)	Yes	The identifier of the project element (structure or task) to which the element version belongs
PARENT_STRUCTURE_VERSION_ID	NUMBER	(15)		The identifier of the structure version to which the task version belongs
STRUCTURE_VERSION_NAME	VARCHAR2	(240)	Yes	User-defined name of the structure version
ELEMENT_VERSION_ID	NUMBER	(15)	Yes	The unique identifier for the element version
PUBLISHED_DATE	DATE			The date that the structure version was published
SCHEDULED_START_DATE	DATE			The scheduled start date of the workplan version
SCHEDULED_FINISH_DATE	DATE			The scheduled finish date of the workplan version
CRITICAL_FLAG	VARCHAR2	(1)		Flag that indicates if the task version is part of the critical path. This is a task-specific attribute.
MILESTONE_FLAG	VARCHAR2	(1)		Flag that indicates if the task version is a milestone. This is a task-specific attribute.
PLANNED_EFFORT	NUMBER	(17)		The Planned Effort for the task.
STRUCTURE_STATUS_CODE	VARCHAR2	(150)		The status of the structure version

Query Text

Cut, paste (and edit) the following text to query this object:


SELECT PROJECT_ID
,      PROJ_ELEMENT_ID
,      PARENT_STRUCTURE_VERSION_ID
,      STRUCTURE_VERSION_NAME
,      ELEMENT_VERSION_ID
,      PUBLISHED_DATE
,      SCHEDULED_START_DATE
,      SCHEDULED_FINISH_DATE
,      CRITICAL_FLAG
,      MILESTONE_FLAG
,      PLANNED_EFFORT
,      STRUCTURE_STATUS_CODE
FROM APPS.PA_STRUCT_PUB_TASK_VERS_V;

Dependencies

[top of page]

APPS.PA_STRUCT_PUB_TASK_VERS_V references the following:

APPS: PA_PROJ_ELEMENT_VERSIONS; PA_PROJ_ELEM_VER_SCHEDULE; PA_PROJ_ELEM_VER_STRUCTURE

APPS.PA_STRUCT_PUB_TASK_VERS_V is not referenced by any database object