DBA Data[Home] [Help]

VIEW: APPS.ZX_EVENT_CLASSES_VL

Source

View Text - Preformatted

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


View Text - HTML Formatted

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