VIEW: APPS.PA_WORKPLAN_OPTIONS_V

Source

View Text - Preformatted

SELECT PPWA.project_id ,PPWA.proj_element_id ,PPE.name ,PPWA.wp_default_display_lvl ,PPWA.wp_approval_reqd_flag ,PPWA.wp_auto_publish_flag ,PPWA.wp_approver_source_id ,PPWA.wp_approver_source_type ,pa_resource_utils.get_res_name_from_type(PPWA.wp_approver_source_type, PPWA.wp_approver_source_id) ,PPWA.WP_ENABLE_VERSION_FLAG ,PPWA.AUTO_PUB_UPON_CREATION_FLAG ,PPWA.AUTO_SYNC_TXN_DATE_FLAG ,PPWA.TXN_DATE_SYNC_BUF_DAYS ,LIFE1.NAME ,LIFE1.ELEMENT_NUMBER ,LIFE2.ELEMENT_VERSION_ID ,LIFE3.PHASE_CODE ,LIFE3.NAME ,LIFE3.ELEMENT_NUMBER ,LIFE4.ELEMENT_VERSION_ID ,LIFE6.WQ_ENABLE_FLAG ,LIFE6.PROJ_PROGRESS_ATTR_ID ,LIFE6.record_version_number ,PPWA.record_version_number ,PPE.record_version_number ,PPWA.SCHEDULE_THIRD_PARTY_FLAG ,PPWA.ALLOW_LOWEST_TSK_DEP_FLAG ,PPWA.AUTO_ROLLUP_SUBPROJ_FLAG ,PPWA.THIRD_PARTY_SCHEDULE_CODE ,PPE.ENABLE_WF_FLAG FROM PA_PROJ_WORKPLAN_ATTR PPWA , PA_PROJ_ELEMENTS PPE , PA_PROJ_ELEMENTS LIFE1, PA_PROJ_ELEMENT_VERSIONS LIFE2, PA_PROJ_ELEMENTS LIFE3, PA_PROJ_ELEMENT_VERSIONS LIFE4, PA_PROJ_PROGRESS_ATTR LIFE6 WHERE PPWA.proj_element_id = PPE.proj_element_id AND PPE.PROJECT_ID <> 0 AND PPWA.LIFECYCLE_VERSION_ID = LIFE2.ELEMENT_VERSION_ID (+) AND LIFE2.PROJ_ELEMENT_ID = LIFE1.PROJ_ELEMENT_ID (+) AND PPWA.CURRENT_PHASE_VERSION_ID = LIFE4.ELEMENT_VERSION_ID (+) AND LIFE4.PROJ_ELEMENT_ID = LIFE3.PROJ_ELEMENT_ID (+) AND LIFE6.OBJECT_TYPE = 'PA_STRUCTURES' AND LIFE6.OBJECT_ID = PPE.PROJ_ELEMENT_ID AND LIFE6.PROJECT_ID = PPE.PROJECT_ID AND LIFE6.STRUCTURE_TYPE = 'WORKPLAN'

View Text - HTML Formatted

SELECT PPWA.PROJECT_ID
, PPWA.PROJ_ELEMENT_ID
, PPE.NAME
, PPWA.WP_DEFAULT_DISPLAY_LVL
, PPWA.WP_APPROVAL_REQD_FLAG
, PPWA.WP_AUTO_PUBLISH_FLAG
, PPWA.WP_APPROVER_SOURCE_ID
, PPWA.WP_APPROVER_SOURCE_TYPE
, PA_RESOURCE_UTILS.GET_RES_NAME_FROM_TYPE(PPWA.WP_APPROVER_SOURCE_TYPE
, PPWA.WP_APPROVER_SOURCE_ID)
, PPWA.WP_ENABLE_VERSION_FLAG
, PPWA.AUTO_PUB_UPON_CREATION_FLAG
, PPWA.AUTO_SYNC_TXN_DATE_FLAG
, PPWA.TXN_DATE_SYNC_BUF_DAYS
, LIFE1.NAME
, LIFE1.ELEMENT_NUMBER
, LIFE2.ELEMENT_VERSION_ID
, LIFE3.PHASE_CODE
, LIFE3.NAME
, LIFE3.ELEMENT_NUMBER
, LIFE4.ELEMENT_VERSION_ID
, LIFE6.WQ_ENABLE_FLAG
, LIFE6.PROJ_PROGRESS_ATTR_ID
, LIFE6.RECORD_VERSION_NUMBER
, PPWA.RECORD_VERSION_NUMBER
, PPE.RECORD_VERSION_NUMBER
, PPWA.SCHEDULE_THIRD_PARTY_FLAG
, PPWA.ALLOW_LOWEST_TSK_DEP_FLAG
, PPWA.AUTO_ROLLUP_SUBPROJ_FLAG
, PPWA.THIRD_PARTY_SCHEDULE_CODE
, PPE.ENABLE_WF_FLAG
FROM PA_PROJ_WORKPLAN_ATTR PPWA
, PA_PROJ_ELEMENTS PPE
, PA_PROJ_ELEMENTS LIFE1
, PA_PROJ_ELEMENT_VERSIONS LIFE2
, PA_PROJ_ELEMENTS LIFE3
, PA_PROJ_ELEMENT_VERSIONS LIFE4
, PA_PROJ_PROGRESS_ATTR LIFE6
WHERE PPWA.PROJ_ELEMENT_ID = PPE.PROJ_ELEMENT_ID
AND PPE.PROJECT_ID <> 0
AND PPWA.LIFECYCLE_VERSION_ID = LIFE2.ELEMENT_VERSION_ID (+)
AND LIFE2.PROJ_ELEMENT_ID = LIFE1.PROJ_ELEMENT_ID (+)
AND PPWA.CURRENT_PHASE_VERSION_ID = LIFE4.ELEMENT_VERSION_ID (+)
AND LIFE4.PROJ_ELEMENT_ID = LIFE3.PROJ_ELEMENT_ID (+)
AND LIFE6.OBJECT_TYPE = 'PA_STRUCTURES'
AND LIFE6.OBJECT_ID = PPE.PROJ_ELEMENT_ID
AND LIFE6.PROJECT_ID = PPE.PROJECT_ID
AND LIFE6.STRUCTURE_TYPE = 'WORKPLAN'