[Home] [Help]
View: FWK_TBX_LOOKUP_CODES_VL
View Text
SELECT B.ROWID ROW_ID
,
B.LOOKUP_TYPE
,
B.LOOKUP_CODE
,
B.START_DATE_ACTIVE
,
B.END_DATE_ACTIVE
,
T.MEANING
,
T.DESCRIPTION
FROM FWK_TBX_LOOKUP_CODES_B B
, FWK_TBX_LOOKUP_CODES_TL T
WHERE B.LOOKUP_TYPE = T.LOOKUP_TYPE
AND B.LOOKUP_CODE = T.LOOKUP_CODE
AND T.LANGUAGE = USERENV('LANG')