VIEW: APPS.BSC_SYS_LABELS_VL

Source

View Text - Preformatted

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')

View Text - HTML Formatted

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')