VIEW: ZX.ZX_FC_CODES_DENORM_B#

Source

View Text - Preformatted

select CLASSIFICATION_TYPE_ID CLASSIFICATION_TYPE_ID, CLASSIFICATION_TYPE_CODE CLASSIFICATION_TYPE_CODE, CLASSIFICATION_TYPE_NAME CLASSIFICATION_TYPE_NAME, CLASSIFICATION_TYPE_CATEG_CODE CLASSIFICATION_TYPE_CATEG_CODE, CLASSIFICATION_ID CLASSIFICATION_ID, CLASSIFICATION_CODE CLASSIFICATION_CODE, CLASSIFICATION_NAME CLASSIFICATION_NAME, LANGUAGE LANGUAGE, EFFECTIVE_FROM EFFECTIVE_FROM, EFFECTIVE_TO EFFECTIVE_TO, ENABLED_FLAG ENABLED_FLAG, ANCESTOR_ID ANCESTOR_ID, ANCESTOR_CODE ANCESTOR_CODE, ANCESTOR_NAME ANCESTOR_NAME, CONCAT_CLASSIF_CODE CONCAT_CLASSIF_CODE, CONCAT_CLASSIF_NAME CONCAT_CLASSIF_NAME, CLASSIFICATION_CODE_LEVEL CLASSIFICATION_CODE_LEVEL, COUNTRY_CODE COUNTRY_CODE, SEGMENT1 SEGMENT1, SEGMENT2 SEGMENT2, SEGMENT3 SEGMENT3, SEGMENT4 SEGMENT4, SEGMENT5 SEGMENT5, SEGMENT6 SEGMENT6, SEGMENT7 SEGMENT7, SEGMENT8 SEGMENT8, SEGMENT9 SEGMENT9, SEGMENT10 SEGMENT10, SEGMENT1_NAME SEGMENT1_NAME, SEGMENT2_NAME SEGMENT2_NAME, SEGMENT3_NAME SEGMENT3_NAME, SEGMENT4_NAME SEGMENT4_NAME, SEGMENT5_NAME SEGMENT5_NAME, SEGMENT6_NAME SEGMENT6_NAME, SEGMENT7_NAME SEGMENT7_NAME, SEGMENT8_NAME SEGMENT8_NAME, SEGMENT9_NAME SEGMENT9_NAME, SEGMENT10_NAME SEGMENT10_NAME, CREATED_BY CREATED_BY, CREATION_DATE CREATION_DATE, LAST_UPDATED_BY LAST_UPDATED_BY, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, LAST_UPDATE_DATE LAST_UPDATE_DATE, REQUEST_ID REQUEST_ID, PROGRAM_ID PROGRAM_ID, PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID, PROGRAM_LOGIN_ID PROGRAM_LOGIN_ID, RECORD_TYPE_CODE RECORD_TYPE_CODE, ZD_EDITION_NAME ZD_EDITION_NAME from "ZX"."ZX_FC_CODES_DENORM_B"

View Text - HTML Formatted

SELECT CLASSIFICATION_TYPE_ID CLASSIFICATION_TYPE_ID
, CLASSIFICATION_TYPE_CODE CLASSIFICATION_TYPE_CODE
, CLASSIFICATION_TYPE_NAME CLASSIFICATION_TYPE_NAME
, CLASSIFICATION_TYPE_CATEG_CODE CLASSIFICATION_TYPE_CATEG_CODE
, CLASSIFICATION_ID CLASSIFICATION_ID
, CLASSIFICATION_CODE CLASSIFICATION_CODE
, CLASSIFICATION_NAME CLASSIFICATION_NAME
, LANGUAGE LANGUAGE
, EFFECTIVE_FROM EFFECTIVE_FROM
, EFFECTIVE_TO EFFECTIVE_TO
, ENABLED_FLAG ENABLED_FLAG
, ANCESTOR_ID ANCESTOR_ID
, ANCESTOR_CODE ANCESTOR_CODE
, ANCESTOR_NAME ANCESTOR_NAME
, CONCAT_CLASSIF_CODE CONCAT_CLASSIF_CODE
, CONCAT_CLASSIF_NAME CONCAT_CLASSIF_NAME
, CLASSIFICATION_CODE_LEVEL CLASSIFICATION_CODE_LEVEL
, COUNTRY_CODE COUNTRY_CODE
, SEGMENT1 SEGMENT1
, SEGMENT2 SEGMENT2
, SEGMENT3 SEGMENT3
, SEGMENT4 SEGMENT4
, SEGMENT5 SEGMENT5
, SEGMENT6 SEGMENT6
, SEGMENT7 SEGMENT7
, SEGMENT8 SEGMENT8
, SEGMENT9 SEGMENT9
, SEGMENT10 SEGMENT10
, SEGMENT1_NAME SEGMENT1_NAME
, SEGMENT2_NAME SEGMENT2_NAME
, SEGMENT3_NAME SEGMENT3_NAME
, SEGMENT4_NAME SEGMENT4_NAME
, SEGMENT5_NAME SEGMENT5_NAME
, SEGMENT6_NAME SEGMENT6_NAME
, SEGMENT7_NAME SEGMENT7_NAME
, SEGMENT8_NAME SEGMENT8_NAME
, SEGMENT9_NAME SEGMENT9_NAME
, SEGMENT10_NAME SEGMENT10_NAME
, CREATED_BY CREATED_BY
, CREATION_DATE CREATION_DATE
, LAST_UPDATED_BY LAST_UPDATED_BY
, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, REQUEST_ID REQUEST_ID
, PROGRAM_ID PROGRAM_ID
, PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID
, PROGRAM_LOGIN_ID PROGRAM_LOGIN_ID
, RECORD_TYPE_CODE RECORD_TYPE_CODE
, ZD_EDITION_NAME ZD_EDITION_NAME
FROM "ZX"."ZX_FC_CODES_DENORM_B"