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_STRUC_TASK_SEARCH_V

Object Details

Object Name:	PA_STRUC_TASK_SEARCH_V
Object Type:	VIEW
Owner:	APPS
FND Design Data:	PA.PA_STRUC_TASK_SEARCH_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, 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.
MILESTONE_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_SYSTEM_STATUS_CODE	VARCHAR2	(30)
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 who manages the task. This is a task-specific attribute.
TASK_MANAGER	VARCHAR2	(240)	The name of the person who manages the task. This is a task-specific attribute.
PARENT_STRUCTURE_VERSION_ID	NUMBER	(15)	The identifier of the structure version to 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)	System-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
PARENT_VER_REC_VER_NUMBER	NUMBER	(15)	Record version number for the parent element version
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
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 for whether or not to include this element in the Project Status Report. Currently, only tasks can 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	(7)	The percentage completed
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
LATEST_EFF_PUBLISHED_FLAG	VARCHAR2	(1)	Flag to indicate that this structure version is the latest published version for each purpose
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
PUBLISHED_DATE	DATE		The date that the structure version was published
LINK_TASK_FLAG	VARCHAR2	(1)	Indicates that a task is used for linking purposes and is not displayed in the user interface
AS_OF_DATE	DATE
REPORT_VERSION_ID	NUMBER
BASELINE_START_DATE	DATE
BASELINE_FINISH_DATE	DATE
SCH_BSL_START_VAR	NUMBER
SCH_BSL_FINISH_VAR	NUMBER
EST_SCH_START_VAR	NUMBER
EST_SCH_FINISH_VAR	NUMBER
ACT_SCH_START_VAR	NUMBER
ACT_SCH_FINISH_VAR	NUMBER
TASK_CREATION_DATE	DATE
ACTIVE_TASK_FLAG	VARCHAR2	(4000)
DAYS_TO_START	NUMBER
DAYS_TO_FINISH	NUMBER

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
,      MILESTONE_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_SYSTEM_STATUS_CODE
,      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
,      PARENT_VER_REC_VER_NUMBER
,      STATUS_ICON_ACTIVE_IND
,      PERCENT_COMPLETE_ID
,      STATUS_ICON_IND
,      STATUS_CODE
,      STATUS_CODE_MEANING
,      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
,      LATEST_EFF_PUBLISHED_FLAG
,      PROJECT_NUMBER
,      PROJECT_NAME
,      PARENT_ELEMENT_ID
,      PUBLISHED_DATE
,      LINK_TASK_FLAG
,      AS_OF_DATE
,      REPORT_VERSION_ID
,      BASELINE_START_DATE
,      BASELINE_FINISH_DATE
,      SCH_BSL_START_VAR
,      SCH_BSL_FINISH_VAR
,      EST_SCH_START_VAR
,      EST_SCH_FINISH_VAR
,      ACT_SCH_START_VAR
,      ACT_SCH_FINISH_VAR
,      TASK_CREATION_DATE
,      ACTIVE_TASK_FLAG
,      DAYS_TO_START
,      DAYS_TO_FINISH
FROM APPS.PA_STRUC_TASK_SEARCH_V;

Dependencies

[top of page]

APPS.PA_STRUC_TASK_SEARCH_V references the following:

APPS: FND_GLOBAL - show dependent code; FND_LOOKUPS; HR_ALL_ORGANIZATION_UNITS; 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; PER_ALL_PEOPLE_F

APPS.PA_STRUC_TASK_SEARCH_V is not referenced by any database object