Product: | PER - Human Resources |
---|---|
Description: | Used to support user interface |
Implementation/DBA Data: | APPS.PER_ORG_STRUCTURE_ELEMENTS_V2 |
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')