View: FII_CCC_VALUES_V

Product:	FII - Financial Intelligence
Description:	View to get company cost center values for webadi upload
Implementation/DBA Data:	APPS.FII_CCC_VALUES_V

View Text

SELECT 'FII_COMPANIES' DIMENSION
, ID
, VALUE
, DESCRIPTION
, IS_LEAF_FLAG
FROM FII_COMPANY_VALUES_V UNION SELECT 'FII_COMPANIES' DIMENSION
, -999 ID
, FND_MESSAGE.GET_STRING('BIS'
, 'ALL') VALUE
, FND_MESSAGE.GET_STRING('BIS'
, 'BIS_GRANTS_ALL_VALUES') DESCRIPTION
, NULL IS_LEAF_FLAG
FROM DUAL UNION SELECT 'HRI_CL_ORGCC' DIMENSION
, ID
, VALUE
, DESCRIPTION
, IS_LEAF_FLAG
FROM FII_COST_CENTER_VALUES_V UNION SELECT 'HRI_CL_ORGCC' DIMENSION
, -999 ID
, FND_MESSAGE.GET_STRING('BIS'
, 'ALL') VALUE
, FND_MESSAGE.GET_STRING('BIS'
, 'BIS_GRANTS_ALL_VALUES') DESCRIPTION
, NULL IS_LEAF_FLAG
FROM DUAL

Columns