View: BISBV_IND_SITE_CUSTOMIZATION

Product:	BIS - Applications BIS
Description:
Implementation/DBA Data:	APPS.BISBV_IND_SITE_CUSTOMIZATION

View Text

SELECT IND.INDICATOR_ID
, IND.SHORT_NAME
, IND.CREATION_DATE
, IND.CREATED_BY
, IND.LAST_UPDATE_DATE
, IND.LAST_UPDATED_BY
, IND.LAST_UPDATE_LOGIN
, IND_TL.NAME
, IND_TL.DESCRIPTION
, NVL(DECODE(IND_CUST.SITE_ID
, 0
, IND_CUST.ENABLED)
, IND.ENABLED) AS ENABLED
, IND.DATASET_ID
FROM BIS_INDICATORS IND
, BIS_INDICATORS_TL IND_TL
, BIS_IND_CUSTOMIZATIONS IND_CUST
WHERE IND.INDICATOR_ID = IND_CUST.INDICATOR_ID (+)
AND IND.INDICATOR_ID = IND_TL.INDICATOR_ID
AND IND_TL.LANGUAGE = USERENV('LANG')
AND NVL(IND.OBSOLETE
, 'F') = 'F'