[Home] [Help]
View: HRI_CL_ORG_SRHL_V
| Product: | HRI - Human Resources Intelligence (Obsolete) |
|---|
| Description: | |
|---|
| Implementation/DBA Data: |
Not implemented in this database
|
|---|
View Text
SELECT DISTINCT OHS.SUB_ORG_RELATIVE_LEVEL ID
, DECODE(OHS.SUB_ORG_RELATIVE_LEVEL
, 0
, '0 '||HR_BIS.BIS_DECODE_LOOKUP('HRI_HRCY_RELATIVE_LEVELS'
, '0_LEVEL')
, 1
, '1 '||HR_BIS.BIS_DECODE_LOOKUP('HRI_HRCY_RELATIVE_LEVELS'
, '1_LEVEL')
, TO_CHAR(OHS.SUB_ORG_RELATIVE_LEVEL) ||' ' ||HR_BIS.BIS_DECODE_LOOKUP('HRI_HRCY_RELATIVE_LEVELS'
, '2_LEVEL') ) VALUE
, HR_GENERAL.START_OF_TIME START_DATE
, HR_GENERAL.END_OF_TIME END_DATE
, FND_GLOBAL.RESP_ID RESPONSIBILITY_ID
, OHS.ORG_HIERARCHY_VERSION_ID ORG_HIERARCHY_VERSION_ID
, OHS.SUP_ORGANIZATION_ID SUP_ORGANIZATION_ID
FROM HRI_CS_ORGH_V OHS WITH READ ONLY
Columns
| Name |
| ID |
| VALUE |
| START_DATE |
| END_DATE |
| RESPONSIBILITY_ID |
| ORG_HIERARCHY_VERSION_ID |
| SUP_ORGANIZATION_ID |