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.

[Home] [Help]

VIEW: PA.PA_PROJ_WORKPLAN_ATTR#

Source

View Text - Preformatted


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

View Text - HTML Formatted

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