SELECT
B.TAX_EVENT_CLASS_CODE,
T.TAX_EVENT_CLASS_NAME,
B.NORMAL_SIGN_FLAG,
B.ASC_INTRCMP_TX_EVNT_CLS_CODE,
B.CREATION_DATE,
B.CREATED_BY ,
B.LAST_UPDATE_DATE ,
B.LAST_UPDATED_BY,
B.LAST_UPDATE_LOGIN
FROM ZX_EVENT_CLASSES_TL T,
ZX_EVENT_CLASSES_B B
WHERE B.TAX_EVENT_CLASS_CODE = T.TAX_EVENT_CLASS_CODE
AND T.LANGUAGE = userenv('LANG')
SELECT
B.TAX_EVENT_CLASS_CODE
,
T.TAX_EVENT_CLASS_NAME
,
B.NORMAL_SIGN_FLAG
,
B.ASC_INTRCMP_TX_EVNT_CLS_CODE
,
B.CREATION_DATE
,
B.CREATED_BY
,
B.LAST_UPDATE_DATE
,
B.LAST_UPDATED_BY
,
B.LAST_UPDATE_LOGIN
FROM ZX_EVENT_CLASSES_TL T
,
ZX_EVENT_CLASSES_B B
WHERE B.TAX_EVENT_CLASS_CODE = T.TAX_EVENT_CLASS_CODE
AND T.LANGUAGE = USERENV('LANG')
|
|
|