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_WORKPLAN_ATTR

Object Details

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

This table stores the workplan attributes for projects.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
PA_PROJ_WORKPLAN_ATTR_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	PROJ_ELEMENT_ID
PA_PROJ_WORKPLAN_ATTR_N1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	PROJECT_ID

Columns

Name	Datatype	Length	Mandatory	Comments
PROJ_ELEMENT_ID	NUMBER	(15)	Yes	The unique identifier for the project element
PROJECT_ID	NUMBER	(15)	Yes	Project Id
LAST_UPDATE_DATE	DATE		Yes	Standard Who Column
LAST_UPDATED_BY	NUMBER	(15)	Yes	Standard Who Column
CREATION_DATE	DATE		Yes	Standard Who Column
CREATED_BY	NUMBER		Yes	Standard Who Column
WP_APPROVAL_REQD_FLAG	VARCHAR2	(1)	Yes	Flag that enables the approval process for workplan versions.
WP_AUTO_PUBLISH_FLAG	VARCHAR2	(1)	Yes	Flag that enables the auto publishing of workplan versions after approval.
WP_DEFAULT_DISPLAY_LVL	NUMBER	(15)	Yes	The default outline level that is displayed when viewing a structure version.
WP_ENABLE_VERSION_FLAG	VARCHAR2	(1)	Yes	When checked, this flag enables versioning for the workplan structure.
AUTO_PUB_UPON_CREATION_FLAG	VARCHAR2	(1)	Yes	When checked, this flag will cause the workplan to be published upon project creation. This flag can be set only in project templates.
AUTO_SYNC_TXN_DATE_FLAG	VARCHAR2	(1)	Yes	When checked, this flag will automatically update the project and all tasks' Transaction Dates with Actual Dates or Scheduled Dates if Actual Dates are not available for the task or project.
WP_APPROVER_SOURCE_ID	NUMBER	(15)		The resource source id of the user selected as approver of workplan versions.
WP_APPROVER_SOURCE_TYPE	NUMBER	(15)		The resource type id of the user selected as approver of workplan versions.
RECORD_VERSION_NUMBER	NUMBER	(15)		Record Version Number
LAST_UPDATE_LOGIN	NUMBER	(15)		Standard Who Column
TXN_DATE_SYNC_BUF_DAYS	NUMBER	(15)		When Transaction Dates are automatically updated, this value will be added to Transaction Finish Dates and subtracted from Transaction Start Dates during the date update process.
LIFECYCLE_VERSION_ID	NUMBER	(15)		The identifier of the lifecycle version that is assigned to the workplan structure. This column is used only when defining a workplan structure
CURRENT_PHASE_VERSION_ID	NUMBER	(15)		The identifier for the current phase version within the lifecycle version for the workplan structure. This column is used only defining/updating the current phase for a workplan structure
SCHEDULE_THIRD_PARTY_FLAG	VARCHAR2	(1)		Flag indicating whether third party software is used for scheduling or not.
ALLOW_LOWEST_TSK_DEP_FLAG	VARCHAR2	(1)		Flag indicating whether or not only lowest tasks allow to have dependency.
AUTO_ROLLUP_SUBPROJ_FLAG	VARCHAR2	(1)		Flag to determine whether the structure version should automatically accept subproject rolled up values.
THIRD_PARTY_SCHEDULE_CODE	VARCHAR2	(30)		The code to determine the third party schedule option.
SOURCE_OBJECT_ID	NUMBER	(15)		Identifier of the object
SOURCE_OBJECT_TYPE	VARCHAR2	(30)		Type of the object
USE_TASK_SCHEDULE_FLAG	VARCHAR2	(1)		Flag indicates whether assignment resource duration will be the same as task duration. Creating this flag at project/template level.

Query Text

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


SELECT PROJ_ELEMENT_ID
,      PROJECT_ID
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
,      WP_APPROVAL_REQD_FLAG
,      WP_AUTO_PUBLISH_FLAG
,      WP_DEFAULT_DISPLAY_LVL
,      WP_ENABLE_VERSION_FLAG
,      AUTO_PUB_UPON_CREATION_FLAG
,      AUTO_SYNC_TXN_DATE_FLAG
,      WP_APPROVER_SOURCE_ID
,      WP_APPROVER_SOURCE_TYPE
,      RECORD_VERSION_NUMBER
,      LAST_UPDATE_LOGIN
,      TXN_DATE_SYNC_BUF_DAYS
,      LIFECYCLE_VERSION_ID
,      CURRENT_PHASE_VERSION_ID
,      SCHEDULE_THIRD_PARTY_FLAG
,      ALLOW_LOWEST_TSK_DEP_FLAG
,      AUTO_ROLLUP_SUBPROJ_FLAG
,      THIRD_PARTY_SCHEDULE_CODE
,      SOURCE_OBJECT_ID
,      SOURCE_OBJECT_TYPE
,      USE_TASK_SCHEDULE_FLAG
FROM PA.PA_PROJ_WORKPLAN_ATTR;

Dependencies

[top of page]

PA.PA_PROJ_WORKPLAN_ATTR does not reference any database object

PA.PA_PROJ_WORKPLAN_ATTR is referenced by following:

PA: PA_PROJ_WORKPLAN_ATTR#