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: HRI_CL_ORG_CC_MGR_SUPH_V

Product:	HRI - Human Resources Intelligence (Obsolete)
Description:
Implementation/DBA Data:	Not implemented in this database

View Text

SELECT CL_CC.ID ID
, CL_CC.VALUE VALUE
, CS_SUP.EFFECTIVE_START_DATE EFFECTIVE_START_DATE
, CS_SUP.EFFECTIVE_END_DATE EFFECTIVE_END_DATE
, CS_SUP.SUP_PERSON_ID SUP_PERSON_ID
, CS_SUP.SUB_PERSON_ID SUB_PERSON_ID
, CS_SUP.SUB_RELATIVE_LEVEL SUB_RELATIVE_LEVEL
, CS_SUP.SUB_ABSOLUTE_LEVEL SUB_ABSOLUTE_LEVEL
FROM HRI_CL_ORG_CC_V CL_CC
, HR_ORGANIZATION_INFORMATION O_MGR
, HRI_CS_SUPH_V CS_SUP
WHERE O_MGR.ORG_INFORMATION_CONTEXT = 'ORGANIZATION NAME ALIAS'
AND CL_CC.ID = O_MGR.ORGANIZATION_ID
AND O_MGR.ORG_INFORMATION2 = CS_SUP.SUB_PERSON_ID

Columns

Name
ID
VALUE
EFFECTIVE_START_DATE
EFFECTIVE_END_DATE
SUP_PERSON_ID
SUB_PERSON_ID
SUB_RELATIVE_LEVEL
SUB_ABSOLUTE_LEVEL