View: PO_CLM_OPERATING_UNITS

Product:	PO - Purchasing
Description:	View that gives all the CLM Operation Units
Implementation/DBA Data:	APPS.PO_CLM_OPERATING_UNITS

View Text

SELECT 'DEFAULT' ORGANIZATION_ID
, 'ALL OPERATING UNITS' NAME
FROM DUAL UNION SELECT TO_CHAR(HROPERATINGUNITS.ORGANIZATION_ID) ORGANIZATION_ID
, HROPERATINGUNITS.NAME
FROM HR_OPERATING_UNITS HROPERATINGUNITS
WHERE TRUNC(SYSDATE) BETWEEN NVL(HROPERATINGUNITS.DATE_FROM
, TRUNC(SYSDATE))
AND NVL(HROPERATINGUNITS.DATE_TO
, TRUNC(SYSDATE))

Columns