eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

View: PER_ORG_STRUCTURE_ELEMENTS_V

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