[Home] [Help] [Dependency Information]
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.
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
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 |
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 |
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
FROM PA.PA_PROJ_WORKPLAN_ATTR;
PA.PA_PROJ_WORKPLAN_ATTR does not reference any database object
PA.PA_PROJ_WORKPLAN_ATTR is referenced by following:
|
|
|