VIEW: APPS.PER_ORG_STRUCTURE_ELEMENTS_V

Source

View Text - Preformatted

SELECT OSE.ROWID , OSE.ORG_STRUCTURE_ELEMENT_ID , OSE.BUSINESS_GROUP_ID , OSE.ORGANIZATION_ID_PARENT , HOU1TL.NAME , OSE.ORG_STRUCTURE_VERSION_ID , OSE.ORGANIZATION_ID_CHILD , HOU2TL.NAME , OSE.REQUEST_ID , OSE.PROGRAM_APPLICATION_ID , OSE.PROGRAM_ID , OSE.PROGRAM_UPDATE_DATE , OSE.LAST_UPDATE_DATE , OSE.LAST_UPDATED_BY , OSE.LAST_UPDATE_LOGIN , OSE.CREATED_BY , OSE.CREATION_DATE , OSE.POSITION_CONTROL_ENABLED_FLAG FROM PER_ORG_STRUCTURE_ELEMENTS OSE , HR_ALL_ORGANIZATION_UNITS HOU1 , HR_ALL_ORGANIZATION_UNITS HOU2 , HR_ALL_ORGANIZATION_UNITS_TL HOU1TL , HR_ALL_ORGANIZATION_UNITS_TL HOU2TL WHERE OSE.ORGANIZATION_ID_PARENT = HOU1.ORGANIZATION_ID AND OSE.ORGANIZATION_ID_CHILD = HOU2.ORGANIZATION_ID AND HOU1.ORGANIZATION_ID = HOU1TL.ORGANIZATION_ID AND HOU2.ORGANIZATION_ID = HOU2TL.ORGANIZATION_ID AND HOU1TL.LANGUAGE = userenv('LANG') AND HOU2TL.LANGUAGE = userenv('LANG')

View Text - HTML Formatted

SELECT OSE.ROWID
, OSE.ORG_STRUCTURE_ELEMENT_ID
, OSE.BUSINESS_GROUP_ID
, OSE.ORGANIZATION_ID_PARENT
, HOU1TL.NAME
, OSE.ORG_STRUCTURE_VERSION_ID
, OSE.ORGANIZATION_ID_CHILD
, HOU2TL.NAME
, OSE.REQUEST_ID
, OSE.PROGRAM_APPLICATION_ID
, OSE.PROGRAM_ID
, OSE.PROGRAM_UPDATE_DATE
, OSE.LAST_UPDATE_DATE
, OSE.LAST_UPDATED_BY
, OSE.LAST_UPDATE_LOGIN
, OSE.CREATED_BY
, OSE.CREATION_DATE
, OSE.POSITION_CONTROL_ENABLED_FLAG
FROM PER_ORG_STRUCTURE_ELEMENTS OSE
, HR_ALL_ORGANIZATION_UNITS HOU1
, HR_ALL_ORGANIZATION_UNITS HOU2
, HR_ALL_ORGANIZATION_UNITS_TL HOU1TL
, HR_ALL_ORGANIZATION_UNITS_TL HOU2TL
WHERE OSE.ORGANIZATION_ID_PARENT = HOU1.ORGANIZATION_ID
AND OSE.ORGANIZATION_ID_CHILD = HOU2.ORGANIZATION_ID
AND HOU1.ORGANIZATION_ID = HOU1TL.ORGANIZATION_ID
AND HOU2.ORGANIZATION_ID = HOU2TL.ORGANIZATION_ID
AND HOU1TL.LANGUAGE = USERENV('LANG')
AND HOU2TL.LANGUAGE = USERENV('LANG')