VIEW: APPS.PER_ORG_STRUCTURE_ELEMENTS_V2

Source

View Text - Preformatted

SELECT POSE.ORG_STRUCTURE_ELEMENT_ID , POSE.ROWID , POSV.ORG_STRUCTURE_VERSION_ID , POS.NAME , POUTL.NAME , POSE.BUSINESS_GROUP_ID , POSE.ORGANIZATION_ID_PARENT , POSE.ORGANIZATION_ID_CHILD , POSE.REQUEST_ID , POSE.PROGRAM_APPLICATION_ID , POSE.PROGRAM_ID , POSE.PROGRAM_UPDATE_DATE , POSE.LAST_UPDATE_DATE , POSE.LAST_UPDATED_BY , POSE.LAST_UPDATE_LOGIN , POSE.CREATED_BY , POSE.CREATION_DATE , POSE.POSITION_CONTROL_ENABLED_FLAG FROM PER_ORG_STRUCTURE_VERSIONS POSV , PER_ORG_STRUCTURE_ELEMENTS POSE , PER_ORGANIZATION_STRUCTURES POS , HR_ALL_ORGANIZATION_UNITS POU , HR_ALL_ORGANIZATION_UNITS_TL POUTL WHERE POSV.ORG_STRUCTURE_VERSION_ID = POSE.ORG_STRUCTURE_VERSION_ID AND POS.ORGANIZATION_STRUCTURE_ID = POSV.ORGANIZATION_STRUCTURE_ID AND POSE.ORGANIZATION_ID_PARENT = POU.ORGANIZATION_ID AND POU.ORGANIZATION_ID = POUTL.ORGANIZATION_ID AND POUTL.LANGUAGE = userenv('LANG')

View Text - HTML Formatted

SELECT POSE.ORG_STRUCTURE_ELEMENT_ID
, POSE.ROWID
, POSV.ORG_STRUCTURE_VERSION_ID
, POS.NAME
, POUTL.NAME
, POSE.BUSINESS_GROUP_ID
, POSE.ORGANIZATION_ID_PARENT
, POSE.ORGANIZATION_ID_CHILD
, POSE.REQUEST_ID
, POSE.PROGRAM_APPLICATION_ID
, POSE.PROGRAM_ID
, POSE.PROGRAM_UPDATE_DATE
, POSE.LAST_UPDATE_DATE
, POSE.LAST_UPDATED_BY
, POSE.LAST_UPDATE_LOGIN
, POSE.CREATED_BY
, POSE.CREATION_DATE
, POSE.POSITION_CONTROL_ENABLED_FLAG
FROM PER_ORG_STRUCTURE_VERSIONS POSV
, PER_ORG_STRUCTURE_ELEMENTS POSE
, PER_ORGANIZATION_STRUCTURES POS
, HR_ALL_ORGANIZATION_UNITS POU
, HR_ALL_ORGANIZATION_UNITS_TL POUTL
WHERE POSV.ORG_STRUCTURE_VERSION_ID = POSE.ORG_STRUCTURE_VERSION_ID
AND POS.ORGANIZATION_STRUCTURE_ID = POSV.ORGANIZATION_STRUCTURE_ID
AND POSE.ORGANIZATION_ID_PARENT = POU.ORGANIZATION_ID
AND POU.ORGANIZATION_ID = POUTL.ORGANIZATION_ID
AND POUTL.LANGUAGE = USERENV('LANG')