View: FII_ALL_BUD_CCC_V

Product:	FII - Financial Intelligence
Description:
Implementation/DBA Data:	APPS.FII_ALL_BUD_CCC_V

View Text

SELECT O.BUSINESS_GROUP_ID
, O.ORGANIZATION_ID
, OTL.NAME
, O.DATE_FROM
, O.DATE_TO
FROM HR_ALL_ORGANIZATION_UNITS O
, HR_ALL_ORGANIZATION_UNITS_TL OTL
, HR_ORGANIZATION_INFORMATION O2
WHERE O.ORGANIZATION_ID = O2.ORGANIZATION_ID
AND O2.ORG_INFORMATION_CONTEXT = 'CLASS'
AND O2.ORG_INFORMATION1 = 'CC'
AND O2.ORG_INFORMATION2 = 'Y'
AND O.ORGANIZATION_ID = OTL.ORGANIZATION_ID
AND OTL.LANGUAGE = USERENV('LANG') ORDER BY 3

Columns