View: PA_WORKPLAN_OPTIONS_V

Product:	PA - Projects
Description:	Single-Org
Implementation/DBA Data:	APPS.PA_WORKPLAN_OPTIONS_V

View Text

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'

Columns