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