[Home] [Help]
View: HRI_CL_ORG_CC_V
Product: | HRI - Human Resources Intelligence |
Description: | |
Implementation/DBA Data: |
APPS.HRI_CL_ORG_CC_V
|
View Text
SELECT ORG.ORGANIZATION_ID ID
, ORGT.NAME VALUE
, ORG.DATE_FROM START_DATE
, NVL(ORG.DATE_TO
, HR_GENERAL.END_OF_TIME) END_DATE
, OINF.ORG_INFORMATION1 SEGEMNTS
, SUBSTR(OINF.ORG_INFORMATION1
, (INSTR(OINF.ORG_INFORMATION1
, '|'
, 1
, 1)+1)
, ( (INSTR(OINF.ORG_INFORMATION1
, '|'
, 1
, 2)) - (INSTR(OINF.ORG_INFORMATION1
, '|'
, 1
, 1)+1)) ) COMPANY
, SUBSTR(OINF.ORG_INFORMATION1
, (INSTR(OINF.ORG_INFORMATION1
, '|'
, 1
, 3)+1) ) COST_CENTER
FROM HR_ORGANIZATION_INFORMATION OINF
, HR_ALL_ORGANIZATION_UNITS ORG
, HR_ALL_ORGANIZATION_UNITS_TL ORGT
WHERE OINF.ORG_INFORMATION_CONTEXT = 'COMPANY COST CENTER'
AND ORG.ORGANIZATION_ID = OINF.ORGANIZATION_ID
AND ORG.ORGANIZATION_ID = ORGT.ORGANIZATION_ID
AND ORGT.LANGUAGE = USERENV('LANG') WITH READ ONLY
Columns
Name |
ID |
VALUE |
START_DATE |
END_DATE |
SEGMENTS |
COMPANY |
COST_CENTER |