VIEW: APPS.HRI_CL_ORG_SRHL_V

Source

View Text - Preformatted

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

View Text - HTML Formatted

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