VIEW: APPS.BSC_TAB_CSF_VL

Source

View Text - Preformatted

SELECT B.TAB_ID, B.CSF_ID, TL.NAME, TL.HELP, B.CSF_TYPE, B.INTERMEDIATE_FLAG FROM BSC_TAB_CSF_B B, BSC_TAB_CSF_TL TL WHERE B.TAB_ID=TL.TAB_ID AND B.CSF_ID = TL.CSF_ID AND TL.LANGUAGE = userenv('LANG')

View Text - HTML Formatted

SELECT B.TAB_ID
, B.CSF_ID
, TL.NAME
, TL.HELP
, B.CSF_TYPE
, B.INTERMEDIATE_FLAG
FROM BSC_TAB_CSF_B B
, BSC_TAB_CSF_TL TL
WHERE B.TAB_ID=TL.TAB_ID
AND B.CSF_ID = TL.CSF_ID
AND TL.LANGUAGE = USERENV('LANG')