FND Design Data [Home] [Help]

View: PER_ORG_STRUCTURE_ELEMENTS_V

Product: PER - Human Resources
Description: Used to support user interface
Implementation/DBA Data: ViewAPPS.PER_ORG_STRUCTURE_ELEMENTS_V
View Text

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')

Columns

Name
ROW_ID
ORG_STRUCTURE_ELEMENT_ID
BUSINESS_GROUP_ID
ORGANIZATION_ID_PARENT
D_PARENT_NAME
ORG_STRUCTURE_VERSION_ID
ORGANIZATION_ID_CHILD
D_CHILD_NAME
REQUEST_ID
PROGRAM_APPLICATION_ID
PROGRAM_ID
PROGRAM_UPDATE_DATE
LAST_UPDATE_DATE
LAST_UPDATED_BY
LAST_UPDATE_LOGIN
CREATED_BY
CREATION_DATE
POSITION_CONTROL_ENABLED_FLAG