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_LATEST_PUB_STRUC_TASKS_V

Object Details

Object Name:	PA_LATEST_PUB_STRUC_TASKS_V
Object Type:	VIEW
Owner:	APPS
FND Design Data:	PA.PA_LATEST_PUB_STRUC_TASKS_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	Comments
ELEMENT_NUMBER	VARCHAR2	(100)	User-defined alphanumeric character that uniquely identifies the element within a project or structure
ELEMENT_NAME	VARCHAR2	(240)	User-defined long name of the element. This value is used for scheduling and progress reporting, and should be used for any new functionality related to Oracle Projects.
DESCRIPTION	VARCHAR2	(2000)	Description of the element
OBJECT_TYPE	VARCHAR2	(30)	The type of the object for the element. The value can be TASK or STRUCTURE.
ELEMENT_VERSION_ID	NUMBER	(15)	The identifier of the element version
PROJ_ELEMENT_ID	NUMBER	(15)	The identifier of the project element
PROJECT_ID	NUMBER	(15)	The identifier of the project to which the structure version or task version belongs
DISPLAY_SEQUENCE	NUMBER	(15)	Identifies the display order of the task version within a structure version. 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.
MILSTONE_FLAG_MEANING	VARCHAR2	(80)	The meaning of the milestone flag status
CRITICAL_FLAG	VARCHAR2	(1)	Flag that indicates if the task version is part of the critical path. This is a task-specific attribute.
CRITICAL_FLAG_MEANING	VARCHAR2	(80)	The meaning of the critical flag status
PARENT_ELEMENT_VERSION_ID	NUMBER	(15)	The identifier of the parent element version
PARENT_OBJECT_TYPE	VARCHAR2	(30)	The type of the object for the parent element. The value can be TASK or STRUCTURE.
RELATIONSHIP_TYPE	VARCHAR2	(30)	The relationship type with respect to the parent
RELATIONSHIP_SUBTYPE	VARCHAR2	(30)	The relationship subtype with respect to the parent
SUMMARY_ELEMENT_FLAG	VARCHAR2	(4000)	Flag that indicates if the task version is a summary task. This is a task-specific attribute.
PROGRESS_STATUS_CODE	VARCHAR2	(150)	Progress status code
PROGRESS_STATUS_MEANING	VARCHAR2	(80)	The meaning of the progress status
PROGRESS_COMMENTS	VARCHAR2	(4000)	The comment of the progress status
SCHEDULED_START_DATE	DATE		The scheduled start date of the workplan version
SCHEDULED_FINISH_DATE	DATE		The scheduled finish date of the workplan version
TASK_MANAGER_ID	NUMBER	(15)	The identifier of the person that manages the task. This is a task-specific attribute.
TASK_MANAGER	VARCHAR2	(240)	The name of the person that manages the task. This is a task-specific attribute.
PARENT_STRUCTURE_VERSION_ID	NUMBER	(15)	The identifier of the structure version which the task version belongs.
WBS_LEVEL	NUMBER	(3)	Identifies the hierarchical level of the task version within a structure version. This is a task-specific attribute.
WBS_NUMBER	VARCHAR2	(240)	Automatically generated formatted number for a task version. This is a task-specific attribute.
ELEM_REC_VER_NUMBER	NUMBER	(15)	Record version number for the project element
ELEM_VER_REC_VER_NUMBER	NUMBER	(15)	Record version number for the project element version
ELEM_VER_SCH_REC_VER_NUMBER	NUMBER	(15)	Record version number for the scheduling information
STATUS_ICON_ACTIVE_IND	VARCHAR2	(80)	Image file of the active image file
PERCENT_COMPLETE_ID	NUMBER	(15)	The identifier for percent complete
STATUS_ICON_IND	VARCHAR2	(80)	Status indicator image
STATUS_CODE	VARCHAR2	(150)	The status code
STATUS_CODE_MEANING	VARCHAR2	(80)	The meaning of the status
SYSTEM_TASK_STATUS_CODE	VARCHAR2	(30)
PRIORITY_CODE	VARCHAR2	(30)	The priority of the task. This is a task-specific attribute.
PRIORITY_DESCRIPTION	VARCHAR2	(80)	The description of the priority
ORGANIZATION_ID	NUMBER	(15)	The identifier of the organization that is responsible for the work. The task organization is copied from the project organization when the task is created. This is a task-specific attribute.
ORGANIZATION_NAME	VARCHAR2	(240)	The name of the organization that is responsible for the work
INCLUDE_IN_PROJ_PROG_RPT	VARCHAR2	(1)	Flag indicating whether or not to include this element in the Project Status Report. Currently, only tasks may be included in the report. This is a task-specific attribute.
ESTIMATED_START_DATE	DATE		The estimated start date of the workplan version
ESTIMATED_FINISH_DATE	DATE		The estimated finish date of the workplan version
ACTUAL_START_DATE	DATE		The actual start date of the workplan version
ACTUAL_FINISH_DATE	DATE		The actual end date of the workplan version
COMPLETED_PERCENTAGE	NUMBER		The percent complete
OBJECT_RELATIONSHIP_ID	NUMBER		The identifier of the relationship
OBJECT_REC_VER_NUMBER	NUMBER		Record version number for the relationship
PEV_SCHEDULE_ID	NUMBER	(15)	The identifier of the scheduling attribute
PROJECT_NUMBER	VARCHAR2	(25)	The number of the project
PROJECT_NAME	VARCHAR2	(30)	The name of the project
PARENT_ELEMENT_ID	NUMBER	(15)	The identifier of the parent element
STRUCTURE_TYPE	VARCHAR2	(150)	The type of the structure type
STRUCTURE_TYPE_CLASS_CODE	VARCHAR2	(30)	The structure type class code
AS_OF_DATE	DATE
BASELINE_START_DATE	DATE
BASELINE_FINISH_DATE	DATE
WQ_PLANNED_QUANTITY	NUMBER	(17)
PLANNED_EFFORT	NUMBER	(17)
TRANSACTION_START_DATE	DATE
TRANSACTION_FINISH_DATE	DATE
SERVICE_TYPE_CODE	VARCHAR2	(30)
WORK_TYPE_ID	NUMBER	(15)
WQ_ENABLE_FLAG	VARCHAR2	(1)
PERCENT_COMP_ENABLE_FLAG	VARCHAR2	(1)
REMAIN_EFFORT_ENABLE_FLAG	VARCHAR2	(1)
INITIAL_PROGRESS_STATUS_CODE	VARCHAR2	(150)
BASE_PERCENT_COMP_DERIV_CODE	VARCHAR2	(30)
TASK_WEIGHTING_DERIV_CODE	VARCHAR2	(0)
WQ_ITEM_CODE	VARCHAR2	(30)
WQ_UOM_CODE	VARCHAR2	(30)
WQ_ACTUAL_ENTRY_CODE	VARCHAR2	(30)
TASK_PROGRESS_ENTRY_PAGE_ID	NUMBER	(15)
PROGRESS_OUTDATED_FLAG	VARCHAR2	(1)
BASELINE_AS_OF_DATE	DATE
SCHEDULE_AS_OF_DATE	DATE
ELEM_ROW_ID	ROWID	(10)
INITIAL_STATUS_CODE	VARCHAR2	(150)
PROG_ENTRY_ENABLE_FLAG	VARCHAR2	(1)
PROG_ENTRY_REQ_FLAG	VARCHAR2	(1)

Query Text

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


SELECT ELEMENT_NUMBER
,      ELEMENT_NAME
,      DESCRIPTION
,      OBJECT_TYPE
,      ELEMENT_VERSION_ID
,      PROJ_ELEMENT_ID
,      PROJECT_ID
,      DISPLAY_SEQUENCE
,      MILESTONE_FLAG
,      MILSTONE_FLAG_MEANING
,      CRITICAL_FLAG
,      CRITICAL_FLAG_MEANING
,      PARENT_ELEMENT_VERSION_ID
,      PARENT_OBJECT_TYPE
,      RELATIONSHIP_TYPE
,      RELATIONSHIP_SUBTYPE
,      SUMMARY_ELEMENT_FLAG
,      PROGRESS_STATUS_CODE
,      PROGRESS_STATUS_MEANING
,      PROGRESS_COMMENTS
,      SCHEDULED_START_DATE
,      SCHEDULED_FINISH_DATE
,      TASK_MANAGER_ID
,      TASK_MANAGER
,      PARENT_STRUCTURE_VERSION_ID
,      WBS_LEVEL
,      WBS_NUMBER
,      ELEM_REC_VER_NUMBER
,      ELEM_VER_REC_VER_NUMBER
,      ELEM_VER_SCH_REC_VER_NUMBER
,      STATUS_ICON_ACTIVE_IND
,      PERCENT_COMPLETE_ID
,      STATUS_ICON_IND
,      STATUS_CODE
,      STATUS_CODE_MEANING
,      SYSTEM_TASK_STATUS_CODE
,      PRIORITY_CODE
,      PRIORITY_DESCRIPTION
,      ORGANIZATION_ID
,      ORGANIZATION_NAME
,      INCLUDE_IN_PROJ_PROG_RPT
,      ESTIMATED_START_DATE
,      ESTIMATED_FINISH_DATE
,      ACTUAL_START_DATE
,      ACTUAL_FINISH_DATE
,      COMPLETED_PERCENTAGE
,      OBJECT_RELATIONSHIP_ID
,      OBJECT_REC_VER_NUMBER
,      PEV_SCHEDULE_ID
,      PROJECT_NUMBER
,      PROJECT_NAME
,      PARENT_ELEMENT_ID
,      STRUCTURE_TYPE
,      STRUCTURE_TYPE_CLASS_CODE
,      AS_OF_DATE
,      BASELINE_START_DATE
,      BASELINE_FINISH_DATE
,      WQ_PLANNED_QUANTITY
,      PLANNED_EFFORT
,      TRANSACTION_START_DATE
,      TRANSACTION_FINISH_DATE
,      SERVICE_TYPE_CODE
,      WORK_TYPE_ID
,      WQ_ENABLE_FLAG
,      PERCENT_COMP_ENABLE_FLAG
,      REMAIN_EFFORT_ENABLE_FLAG
,      INITIAL_PROGRESS_STATUS_CODE
,      BASE_PERCENT_COMP_DERIV_CODE
,      TASK_WEIGHTING_DERIV_CODE
,      WQ_ITEM_CODE
,      WQ_UOM_CODE
,      WQ_ACTUAL_ENTRY_CODE
,      TASK_PROGRESS_ENTRY_PAGE_ID
,      PROGRESS_OUTDATED_FLAG
,      BASELINE_AS_OF_DATE
,      SCHEDULE_AS_OF_DATE
,      ELEM_ROW_ID
,      INITIAL_STATUS_CODE
,      PROG_ENTRY_ENABLE_FLAG
,      PROG_ENTRY_REQ_FLAG
FROM APPS.PA_LATEST_PUB_STRUC_TASKS_V;

Dependencies

[top of page]

APPS.PA_LATEST_PUB_STRUC_TASKS_V references the following:

APPS: FND_GLOBAL - show dependent code; FND_LOOKUPS; HR_ALL_ORGANIZATION_UNITS_TL; PA_LOOKUPS; PA_OBJECT_RELATIONSHIPS; PA_PERCENT_COMPLETES; PA_PROJECTS_ALL; PA_PROJECT_STATUSES; PA_PROJ_ELEMENTS; PA_PROJ_ELEMENTS_UTILS - show dependent code; PA_PROJ_ELEMENT_VERSIONS; PA_PROJ_ELEM_VER_SCHEDULE; PA_PROJ_ELEM_VER_STRUCTURE; PA_PROJ_PROGRESS_ATTR; PA_PROJ_STRUCTURE_TYPES; PA_STRUCTURE_TYPES; PA_TASKS; PA_TASK_TYPES; PER_ALL_PEOPLE_F

APPS.PA_LATEST_PUB_STRUC_TASKS_V is referenced by following:

APPS: PA_TASK_PROG_HIST_V