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]

TABLE: PA.PA_PROJ_ELEMENTS

Object Details

Object Name:	PA_PROJ_ELEMENTS
Object Type:	TABLE
Owner:	PA
FND Design Data:	PA.PA_PROJ_ELEMENTS
Subobject Name:
Status:	VALID

PA_PROJ_ELEMENTS stores the common non-versioned information related to tasks and structures. - For future use

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
PA_PROJ_ELEMENTS_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	PROJ_ELEMENT_ID
PA_PROJ_ELEMENTS_U2	NORMAL	UNIQUE	APPS_TS_TX_IDX	PROJECT_ID OBJECT_TYPE ELEMENT_NUMBER PARENT_STRUCTURE_ID
PA_PROJ_ELEMENTS_N1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	MANAGER_PERSON_ID
PA_PROJ_ELEMENTS_N2	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	ATTRIBUTE15

Columns

Name	Datatype	Length	Mandatory	Comments
PROJ_ELEMENT_ID	NUMBER	(15)	Yes	The unique identifier for the project element (uses the same sequence as PA_TASKS_S)
PROJECT_ID	NUMBER	(15)	Yes	The identifier of the project to which the element belongs
OBJECT_TYPE	VARCHAR2	(30)	Yes	The type of the object for the element. The value can be TASK or STRUCTURE.
ELEMENT_NUMBER	VARCHAR2	(100)		User-defined number that uniquely identifies the element within a project or structure
NAME	VARCHAR2	(240)	Yes	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.
CREATION_DATE	DATE		Yes	Standard Who column
CREATED_BY	NUMBER	(15)	Yes	Standard Who column
LAST_UPDATE_DATE	DATE		Yes	Standard Who column
LAST_UPDATED_BY	NUMBER	(15)	Yes	Standard Who column
DESCRIPTION	VARCHAR2	(2000)		Description of the element
STATUS_CODE	VARCHAR2	(150)		The status of the project element
WF_STATUS_CODE	VARCHAR2	(30)		The status of workflow associated with the element
PM_SOURCE_CODE	VARCHAR2	(30)		The identifier of the source system from which the element version was created
PM_SOURCE_REFERENCE	VARCHAR2	(25)		The identifier of the element version in the source system from which the element was imported
CLOSED_DATE	DATE			The date that the element status was set to Closed. This is a task-specific attribute.
LOCATION_ID	NUMBER	(15)		The location where the task is performed. This is a task-specific attribute.
MANAGER_PERSON_ID	NUMBER	(15)		The identifier of the person who manages the task. This is a task-specific attribute.
CARRYING_OUT_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.
TYPE_CODE	VARCHAR2	(30)		The type that the user specifies for the task. This is a task-specific attribute.
PRIORITY_CODE	VARCHAR2	(30)		The priority of the task. This is a task-specific attribute.
INC_PROJ_PROGRESS_FLAG	VARCHAR2	(1)		Not used.
RECORD_VERSION_NUMBER	NUMBER	(15)		Sequence number for lock strategy in self-service applications
LAST_UPDATE_LOGIN	NUMBER	(15)		Standard Who column
REQUEST_ID	NUMBER	(15)		Standard Who column
PROGRAM_APPLICATION_ID	NUMBER	(15)		Standard Who column
PROGRAM_ID	NUMBER	(15)		Standard Who column
PROGRAM_UPDATE_DATE	DATE			Standard Who column
ATTRIBUTE_CATEGORY	VARCHAR2	(30)		Descriptive flexfield context field
ATTRIBUTE1	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE2	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE3	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE4	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE5	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE6	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE7	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE8	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE9	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE10	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE11	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE12	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE13	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE14	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE15	VARCHAR2	(150)		Descriptive flexfield segment
LINK_TASK_FLAG	VARCHAR2	(1)		Indicates that a task is used for linking purposes and is not displayed in the user interface
BASELINE_START_DATE	DATE			Baseline start date for the task or the workplan.
BASELINE_FINISH_DATE	DATE			Baseline finish date for the task or the workplan.
PROGRESS_OUTDATED_FLAG	VARCHAR2	(1)		Indicates if the user-entered progress information is outdated.
WQ_ITEM_CODE	VARCHAR2	(30)		The Work Item for Work Quantity for a task.
WQ_UOM_CODE	VARCHAR2	(30)		The Unit of Measure used for Work Quantity for a task.
WQ_ACTUAL_ENTRY_CODE	VARCHAR2	(30)		The Actual Work Quantity Entry Method Code.
TASK_PROGRESS_ENTRY_PAGE_ID	NUMBER	(15)		The page layout ID for the Additional Information section of the Task Progress Details page
PARENT_STRUCTURE_ID	NUMBER	(15)		The identifier for the parent structure.
BASELINE_DURATION	NUMBER			Duration between the Baseline Start and Finish Dates using the project work calendar.
PHASE_CODE	VARCHAR2	(150)		Used only for project element records that are for lifecycle phases. This is the reference to the phase that is to be used for this lifecycle phase. Phases are defined externally from lifecycles, and are then referenced within them.
PHASE_VERSION_ID	NUMBER	(15)		Used only for project element records that are for top tasks. The identifier of the phase version which is assigned to this workplan top task. Phases are only assigned to tasks within a workplan structure.
TYPE_ID	NUMBER	(15)		The type that the user specifies for the task. This is a task-specific attribute.
PROGRESS_WEIGHT	NUMBER	(17)		User entered absolute weight.
BASE_PERCENT_COMP_DERIV_CODE	VARCHAR2	(30)		The derivation method for Base % Complete
FUNCTION_CODE	VARCHAR2	(30)		Identifies the action function.
ENABLE_WF_FLAG	VARCHAR2	(1)		Enable Workflow for managing the task execution
WF_ITEM_TYPE	VARCHAR2	(30)		Task Execution Workflow Item Type
WF_PROCESS	VARCHAR2	(30)		Task Execution Workflow Process
WF_START_LEAD_DAYS	NUMBER	(15)		The number of days by which the task execution workflow will be started before the task schedule start date.
SOURCE_OBJECT_ID	NUMBER	(15)		Identifier of the object
SOURCE_OBJECT_TYPE	VARCHAR2	(30)		Type of the object

Query Text

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


SELECT PROJ_ELEMENT_ID
,      PROJECT_ID
,      OBJECT_TYPE
,      ELEMENT_NUMBER
,      NAME
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      DESCRIPTION
,      STATUS_CODE
,      WF_STATUS_CODE
,      PM_SOURCE_CODE
,      PM_SOURCE_REFERENCE
,      CLOSED_DATE
,      LOCATION_ID
,      MANAGER_PERSON_ID
,      CARRYING_OUT_ORGANIZATION_ID
,      TYPE_CODE
,      PRIORITY_CODE
,      INC_PROJ_PROGRESS_FLAG
,      RECORD_VERSION_NUMBER
,      LAST_UPDATE_LOGIN
,      REQUEST_ID
,      PROGRAM_APPLICATION_ID
,      PROGRAM_ID
,      PROGRAM_UPDATE_DATE
,      ATTRIBUTE_CATEGORY
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
,      LINK_TASK_FLAG
,      BASELINE_START_DATE
,      BASELINE_FINISH_DATE
,      PROGRESS_OUTDATED_FLAG
,      WQ_ITEM_CODE
,      WQ_UOM_CODE
,      WQ_ACTUAL_ENTRY_CODE
,      TASK_PROGRESS_ENTRY_PAGE_ID
,      PARENT_STRUCTURE_ID
,      BASELINE_DURATION
,      PHASE_CODE
,      PHASE_VERSION_ID
,      TYPE_ID
,      PROGRESS_WEIGHT
,      BASE_PERCENT_COMP_DERIV_CODE
,      FUNCTION_CODE
,      ENABLE_WF_FLAG
,      WF_ITEM_TYPE
,      WF_PROCESS
,      WF_START_LEAD_DAYS
,      SOURCE_OBJECT_ID
,      SOURCE_OBJECT_TYPE
FROM PA.PA_PROJ_ELEMENTS;

Dependencies

[top of page]

PA.PA_PROJ_ELEMENTS does not reference any database object

PA.PA_PROJ_ELEMENTS is referenced by following:

APPS: PA_PROJ_ELEMENTS