View: HRI_CL_ORG_HR_HX_V

Product:	HRI - Human Resources Intelligence (Obsolete)
Description:
Implementation/DBA Data:	APPS.HRI_CL_ORG_HR_HX_V

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
FROM HR_ORGANIZATION_UNITS ORG
, HR_ORGANIZATION_INFORMATION INF
WHERE ORG.ORGANIZATION_ID = INF.ORGANIZATION_ID
AND INF.ORG_INFORMATION1 = 'HR_ORG'
AND TRUNC(SYSDATE) BETWEEN ORG.DATE_FROM
AND NVL(ORG.DATE_TO
, HR_GENERAL.END_OF_TIME) UNION ALL SELECT -1 ID
, '' VALUE
, HR_GENERAL.START_OF_TIME START_DATE
, HR_GENERAL.END_OF_TIME END_DATE
, FND_GLOBAL.RESP_ID RESPONSIBILITY_ID
, -1 BUSINESS_GROUP_ID
FROM DUAL WITH READ ONLY

Columns