[Home] [Help]
View: HRI_CL_ORG_INHV_H_V
Product: | HRI - Human Resources Intelligence (Obsolete) |
Description: | |
Implementation/DBA Data: |
Not implemented in this database
|
View Text
SELECT ORG.ORGANIZATION_ID ID
, ORG.NAME VALUE
, ORG.DATE_FROM START_DATE
, NVL(ORG.DATE_TO
, HR_GENERAL.END_OF_TIME) END_DATE
, FND_GLOBAL.RESP_ID RESPONSIBILITY_ID
, ORG.BUSINESS_GROUP_ID BUSINESS_GROUP_ID
, OHS.ORG_HIERARCHY_VERSION_ID ORG_HIERARCHY_VERSION_ID
FROM HR_ORGANIZATION_UNITS ORG
, HRI_CS_ORGH_V OHS
WHERE OHS.SUB_ORG_RELATIVE_LEVEL = 0
AND ORG.ORGANIZATION_ID = OHS.SUP_ORGANIZATION_ID WITH READ ONLY
Columns
Name |
ID |
VALUE |
START_DATE |
END_DATE |
RESPONSIBILITY_ID |
BUSINESS_GROUP_ID |
ORG_HIERARCHY_VERSION_ID |