VIEW: APPS.ZX_REPORTING_TYPES_VL

Source

View Text - Preformatted

select
    B.ROWID ROW_ID,
    B.REPORTING_TYPE_ID,
    B.REPORTING_TYPE_CODE,
    B.REPORTING_TYPE_DATATYPE_CODE,
    B.TAX_REGIME_CODE,
    B.TAX,
    B.FORMAT_MASK,
    B.MIN_LENGTH,
    B.MAX_LENGTH,
    B.LEGAL_MESSAGE_FLAG,
    B.EFFECTIVE_FROM,
    B.EFFECTIVE_TO,
    B.HAS_REPORTING_CODES_FLAG,
    B.OBJECT_VERSION_NUMBER,
    B.RECORD_TYPE_CODE,
    B.CREATED_BY,
    B.CREATION_DATE,
    B.LAST_UPDATED_BY,
    B.LAST_UPDATE_DATE,
    B.LAST_UPDATE_LOGIN,
    B.REQUEST_ID,
    B.PROGRAM_APPLICATION_ID,
    B.PROGRAM_ID,
    B.PROGRAM_LOGIN_ID,
    T.REPORTING_TYPE_NAME
  from ZX_REPORTING_TYPES_TL T, ZX_REPORTING_TYPES_B B
  where B.REPORTING_TYPE_ID = T.REPORTING_TYPE_ID
  and T.LANGUAGE = userenv('LANG')

   

View Text - HTML Formatted

SELECT B.ROWID ROW_ID
, B.REPORTING_TYPE_ID
, B.REPORTING_TYPE_CODE
, B.REPORTING_TYPE_DATATYPE_CODE
, B.TAX_REGIME_CODE
, B.TAX
, B.FORMAT_MASK
, B.MIN_LENGTH
, B.MAX_LENGTH
, B.LEGAL_MESSAGE_FLAG
, B.EFFECTIVE_FROM
, B.EFFECTIVE_TO
, B.HAS_REPORTING_CODES_FLAG
, B.OBJECT_VERSION_NUMBER
, B.RECORD_TYPE_CODE
, B.CREATED_BY
, B.CREATION_DATE
, B.LAST_UPDATED_BY
, B.LAST_UPDATE_DATE
, B.LAST_UPDATE_LOGIN
, B.REQUEST_ID
, B.PROGRAM_APPLICATION_ID
, B.PROGRAM_ID
, B.PROGRAM_LOGIN_ID
, T.REPORTING_TYPE_NAME
FROM ZX_REPORTING_TYPES_TL T
, ZX_REPORTING_TYPES_B B
WHERE B.REPORTING_TYPE_ID = T.REPORTING_TYPE_ID
AND T.LANGUAGE = USERENV('LANG')