View: BSC_SYS_LABELS_VL

Product:	BSC - Balanced Scorecard
Description:	View of BSC_SYS_LABELS_B and BSC_SYS_LABELS_TL.
Implementation/DBA Data:	APPS.BSC_SYS_LABELS_VL

View Text

SELECT B.SOURCE_TYPE
, B.SOURCE_CODE
, B.LABEL_ID
, TL.NAME
, B.LEFT_POSITION
, B.TOP_POSITION
, B.FONT_SIZE
, B.FONT_STYLE FROM BSC_SYS_LABELS_B B
, BSC_SYS_LABELS_TL TL
WHERE B.SOURCE_TYPE = TL.SOURCE_TYPE
AND B.SOURCE_CODE = TL.SOURCE_CODE
AND B.LABEL_ID = TL.LABEL_ID
AND TL.LANGUAGE = USERENV('LANG')

Columns