View: PA_STRUCTURE_VERSIONS_V

Product:	PA - Projects
Description:	PA_STRUCTURE_VERSIONS_V selects all structure-related attributes. - For future use
Implementation/DBA Data:	APPS.PA_STRUCTURE_VERSIONS_V

View Text

SELECT ELE.PROJ_ELEMENT_ID
, EVR.ELEMENT_VERSION_ID
, STC.PEV_STRUCTURE_ID
, EVR.PROJECT_ID
, ELE.ELEMENT_NUMBER
, ELE.NAME
, STC.VERSION_NUMBER
, STC.NAME
, STC.DESCRIPTION
, SCH.SCHEDULED_START_DATE
, SCH.SCHEDULED_FINISH_DATE
, SCH.ESTIMATED_START_DATE
, SCH.ESTIMATED_FINISH_DATE
, SCH.ACTUAL_START_DATE
, SCH.ACTUAL_FINISH_DATE
, STC.EFFECTIVE_DATE
, STC.STATUS_CODE
, ST1.PROJECT_STATUS_NAME
, STC.LOCK_STATUS_CODE
, ST2.MEANING
, STC.LOCKED_DATE
, STC.LOCKED_BY_PERSON_ID
, PP1.FULL_NAME
, STC.PUBLISHED_DATE
, STC.PUBLISHED_BY_PERSON_ID
, PP2.FULL_NAME
, STC.ORIGINAL_FLAG
, LK1.MEANING
, STC.CURRENT_FLAG
, LK2.MEANING
, STC.LATEST_EFF_PUBLISHED_FLAG
, LK3.MEANING
, PST.STRUCTURE_TYPE
, ELE.RECORD_VERSION_NUMBER
, EVR.RECORD_VERSION_NUMBER
, STC.RECORD_VERSION_NUMBER
, SCH.RECORD_VERSION_NUMBER
, STC.WBS_RECORD_VERSION_NUMBER
, PPC.PROGRESS_STATUS_CODE
, PPS.PROJECT_STATUS_NAME
, PPC.PROGRESS_COMMENT
, PPC.DESCRIPTION
, PPC.PERCENT_COMPLETE_ID
, PPS.STATUS_ICON_ACTIVE_IND
, PPS.STATUS_ICON_IND
, TO_DATE(NULL)
, TO_DATE(NULL)
, TO_DATE(NULL)
, TO_DATE(NULL)
, PPC.COMPLETED_PERCENTAGE
, PPC.DATE_COMPUTED
, ELE.MANAGER_PERSON_ID
, PAPF.FULL_NAME
, TO_NUMBER(NULL)
, ELE.BASELINE_START_DATE
, ELE.BASELINE_FINISH_DATE
, SCH.SCHEDULED_START_DATE - ELE.BASELINE_START_DATE
, SCH.SCHEDULED_FINISH_DATE - ELE.BASELINE_FINISH_DATE
, SCH.ESTIMATED_START_DATE - SCH.SCHEDULED_START_DATE
, SCH.ESTIMATED_FINISH_DATE - SCH.SCHEDULED_FINISH_DATE
, SCH.ACTUAL_START_DATE - SCH.SCHEDULED_START_DATE
, SCH.ACTUAL_FINISH_DATE - SCH.SCHEDULED_FINISH_DATE
, STC.CHANGE_REASON_CODE
, LU.MEANING
, TO_NUMBER(NULL)
, SCH.LAST_UPDATE_DATE
, PPA.BASELINE_AS_OF_DATE
, PPRU.LAST_UPDATE_DATE
, PPRU.LAST_UPDATE_DATE
, SCH.PLANNED_EFFORT
, PA_PROJECT_STRUCTURE_UTILS.GET_STRUC_TYPE_FOR_STRUCTURE(ELE.PROJ_ELEMENT_ID
, 'FINANCIAL')
, SCH.CALENDAR_ID
, JC.CALENDAR_NAME
, PPRU.ESTIMATED_REMAINING_EFFORT
, NULL
, PPPA.WQ_ENABLE_FLAG
, PPPA.PERCENT_COMP_ENABLE_FLAG
, PPPA.REMAIN_EFFORT_ENABLE_FLAG
, PA_WORKPLAN_ATTR_UTILS.CHECK_WP_VERSIONING_ENABLED(ELE.PROJECT_ID)
, PA_PROJ_ELEMENTS_UTILS.CONVERT_HR_TO_DAYS(SCH.DURATION)
, PA_PROJ_ELEMENTS_UTILS.CONVERT_HR_TO_DAYS(ELE.BASELINE_DURATION)
, PA_PROJ_ELEMENTS_UTILS.CONVERT_HR_TO_DAYS(SCH.ESTIMATED_DURATION)
, PA_PROJ_ELEMENTS_UTILS.CONVERT_HR_TO_DAYS(SCH.ACTUAL_DURATION)
, PPWA.LIFECYCLE_VERSION_ID
, PPE2.NAME
, PPE2.ELEMENT_NUMBER
, PPWA.CURRENT_PHASE_VERSION_ID
, PPE3.NAME
, PPE3.ELEMENT_NUMBER
, PA_PROJ_ELEMENTS_UTILS.CHECK_CHILD_ELEMENT_EXIST(EVR.ELEMENT_VERSION_ID)
FROM PA_PROJ_ELEM_VER_SCHEDULE SCH
, PA_PROJECT_STATUSES ST1
, PA_LOOKUPS ST2
, PA_LOOKUPS LU
, PER_ALL_PEOPLE_F PP1
, PER_ALL_PEOPLE_F PP2
, FND_LOOKUPS LK1
, FND_LOOKUPS LK2
, FND_LOOKUPS LK3
, PA_PROJ_STRUCTURE_TYPES PPST
, PA_STRUCTURE_TYPES PST
, PER_ALL_PEOPLE_F PAPF
, JTF_CALENDARS_TL JC
, PA_PERCENT_COMPLETES PPC
, PA_PROJECT_STATUSES PPS
, PA_PROGRESS_ROLLUP PPRU
, PA_PROJ_PROGRESS_ATTR PPPA
, PA_PROJECTS_ALL PPA
, PA_PROJ_WORKPLAN_ATTR PPWA
, PA_PROJ_ELEMENT_VERSIONS PPEV2
, PA_PROJ_ELEMENT_VERSIONS PPEV3
, PA_PROJ_ELEMENTS PPE2
, PA_PROJ_ELEMENTS PPE3
, PA_PROJ_ELEM_VER_STRUCTURE STC
, PA_PROJ_ELEMENTS ELE
, PA_PROJ_ELEMENT_VERSIONS EVR
WHERE EVR.PROJ_ELEMENT_ID = ELE.PROJ_ELEMENT_ID
AND STC.ELEMENT_VERSION_ID = EVR.ELEMENT_VERSION_ID
AND STC.PROJECT_ID = EVR.PROJECT_ID
AND SCH.ELEMENT_VERSION_ID (+) = EVR.ELEMENT_VERSION_ID
AND SCH.PROJECT_ID (+) = EVR.PROJECT_ID
AND ST1.PROJECT_STATUS_CODE = STC.STATUS_CODE
AND ST2.LOOKUP_CODE (+) = STC.LOCK_STATUS_CODE
AND ST2.LOOKUP_TYPE (+) = 'PA_PEV_LOCK_STATUS'
AND ELE.PROJ_ELEMENT_ID = PPST.PROJ_ELEMENT_ID
AND PPST.STRUCTURE_TYPE_ID = PST.STRUCTURE_TYPE_ID
AND LK1.LOOKUP_TYPE (+) = 'YES_NO'
AND LK1.LOOKUP_CODE (+) = STC.ORIGINAL_FLAG
AND LK2.LOOKUP_TYPE (+) = 'YES_NO'
AND LK2.LOOKUP_CODE (+) = STC.CURRENT_FLAG
AND LK3.LOOKUP_TYPE (+) = 'YES_NO'
AND LK3.LOOKUP_CODE (+) = STC.LATEST_EFF_PUBLISHED_FLAG
AND PP1.PERSON_ID (+) = STC.LOCKED_BY_PERSON_ID
AND SYSDATE BETWEEN PP1.EFFECTIVE_START_DATE(+)
AND PP1.EFFECTIVE_END_DATE(+)
AND PP2.PERSON_ID (+) = STC.PUBLISHED_BY_PERSON_ID
AND SYSDATE BETWEEN PP2.EFFECTIVE_START_DATE(+)
AND PP2.EFFECTIVE_END_DATE(+)
AND ELE.MANAGER_PERSON_ID = PAPF.PERSON_ID(+)
AND SYSDATE BETWEEN PAPF.EFFECTIVE_START_DATE(+)
AND PAPF.EFFECTIVE_END_DATE (+)
AND STC.CHANGE_REASON_CODE = LU.LOOKUP_CODE(+)
AND LU.LOOKUP_TYPE(+) = 'PA_WORKPLAN_CHANGE_REASON'
AND SCH.CALENDAR_ID = JC.CALENDAR_ID (+)
AND JC.LANGUAGE (+) = USERENV('LANG')
AND ELE.PROJECT_ID = PPC.PROJECT_ID(+)
AND ELE.PROJ_ELEMENT_ID = PPC.OBJECT_ID(+)
AND ELE.OBJECT_TYPE = PPC.OBJECT_TYPE(+)
AND NVL( PPC.CURRENT_FLAG(+)
, 'N' ) = 'Y'
AND PPC.PROGRESS_STATUS_CODE = PPS.PROJECT_STATUS_CODE(+)
AND PPC.PROJECT_ID = PPRU.PROJECT_ID (+)
AND PPC.OBJECT_TYPE = PPRU.OBJECT_TYPE (+)
AND PPC.OBJECT_ID = PPRU.OBJECT_ID(+)
AND PPC.DATE_COMPUTED = PPRU.AS_OF_DATE (+)
AND PPPA.PROJECT_ID (+) = ELE.PROJECT_ID
AND PPPA.OBJECT_TYPE (+) = 'PA_STRUCTURES'
AND PPPA.OBJECT_ID (+) = ELE.PROJ_ELEMENT_ID
AND ELE.PROJECT_ID = PPA.PROJECT_ID
AND STC.PROJECT_ID <> 0
AND ELE.PROJ_ELEMENT_ID = PPWA.PROJ_ELEMENT_ID (+)
AND PPWA.LIFECYCLE_VERSION_ID = PPEV2.ELEMENT_VERSION_ID (+)
AND PPEV2.PROJ_ELEMENT_ID = PPE2.PROJ_ELEMENT_ID (+)
AND PPWA.CURRENT_PHASE_VERSION_ID = PPEV3.ELEMENT_VERSION_ID (+)
AND PPEV3.PROJ_ELEMENT_ID = PPE3.PROJ_ELEMENT_ID (+)

Columns