View: PA_FIN_STRUCTURE_VERSIONS_V

Product:	PA - Projects
Description:	PA_FIN_STRUCTURE_VERSIONS_V selects all structure-related attributes.
Implementation/DBA Data:	APPS.PA_FIN_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
, 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
, STC.WBS_RECORD_VERSION_NUMBER
, ELE.MANAGER_PERSON_ID
, PAPF.FULL_NAME
, ELE.BASELINE_START_DATE
, ELE.BASELINE_FINISH_DATE
, STC.CHANGE_REASON_CODE
, LU.MEANING
, PPA.BASELINE_AS_OF_DATE
, PA_PROJECT_STRUCTURE_UTILS.GET_STRUC_TYPE_FOR_STRUCTURE(ELE.PROJ_ELEMENT_ID
, 'WORKPLAN')
, PA_PROJ_ELEMENTS_UTILS.CHECK_CHILD_ELEMENT_EXIST(EVR.ELEMENT_VERSION_ID)
FROM 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
, PA_PROJECTS_ALL PPA
, 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 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 ELE.PROJECT_ID = PPA.PROJECT_ID
AND STC.PROJECT_ID <> 0

Columns