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, ppwa.use_task_schedule_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
, PPWA.USE_TASK_SCHEDULE_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'