[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 |