ZX_FC_CODES_DENORM_VL

Details

• Schema: FUSION

• Object owner: FND

• Object type: VIEW

Columns

Name

ROW_ID CLASSIFICATION_CODES_DENORM_ID CLASSIFICATION_TYPE_ID OBJECT_VERSION_NUMBER CLASSIFICATION_TYPE_CODE CLASSIFICATION_TYPE_CATEG_CODE CLASSIFICATION_ID CLASSIFICATION_CODE EFFECTIVE_FROM EFFECTIVE_TO ENABLED_FLAG ANCESTOR_ID ANCESTOR_CODE CONCAT_CLASSIF_CODE CLASSIFICATION_CODE_LEVEL COUNTRY_CODE SEGMENT1 SEGMENT2 SEGMENT3 SEGMENT4 SEGMENT5 SEGMENT6 SEGMENT7 SEGMENT8 SEGMENT9 SEGMENT10 CREATED_BY CREATION_DATE LAST_UPDATED_BY LAST_UPDATE_LOGIN LAST_UPDATE_DATE REQUEST_ID PROGRAM_LOGIN_ID RECORD_TYPE_CODE PROGRAM_NAME PROGRAM_APP_NAME CLASSIFICATION_TYPE_NAME CLASSIFICATION_NAME ANCESTOR_NAME CONCAT_CLASSIF_NAME SEGMENT1_NAME SEGMENT2_NAME SEGMENT3_NAME SEGMENT4_NAME SEGMENT5_NAME SEGMENT6_NAME SEGMENT7_NAME SEGMENT8_NAME SEGMENT9_NAME SEGMENT10_NAME

Query

SQL_Statement

select B.ROWID ROW_ID, B.CLASSIFICATION_CODES_DENORM_ID, B.CLASSIFICATION_TYPE_ID, B.OBJECT_VERSION_NUMBER, B.CLASSIFICATION_TYPE_CODE, B.CLASSIFICATION_TYPE_CATEG_CODE, B.CLASSIFICATION_ID, B.CLASSIFICATION_CODE, B.EFFECTIVE_FROM, B.EFFECTIVE_TO, B.ENABLED_FLAG, B.ANCESTOR_ID, B.ANCESTOR_CODE, B.CONCAT_CLASSIF_CODE, B.CLASSIFICATION_CODE_LEVEL, B.COUNTRY_CODE, B.SEGMENT1, B.SEGMENT2, B.SEGMENT3, B.SEGMENT4, B.SEGMENT5, B.SEGMENT6, B.SEGMENT7, B.SEGMENT8, B.SEGMENT9, B.SEGMENT10, B.CREATED_BY, B.CREATION_DATE, B.LAST_UPDATED_BY, B.LAST_UPDATE_LOGIN, B.LAST_UPDATE_DATE, B.REQUEST_ID, B.PROGRAM_LOGIN_ID, B.RECORD_TYPE_CODE, B.PROGRAM_NAME, B.PROGRAM_APP_NAME, T.CLASSIFICATION_TYPE_NAME, T.CLASSIFICATION_NAME, T.ANCESTOR_NAME, T.CONCAT_CLASSIF_NAME, T.SEGMENT1_NAME, T.SEGMENT2_NAME, T.SEGMENT3_NAME, T.SEGMENT4_NAME, T.SEGMENT5_NAME, T.SEGMENT6_NAME, T.SEGMENT7_NAME, T.SEGMENT8_NAME, T.SEGMENT9_NAME, T.SEGMENT10_NAME from zx_fc_codes_denorm_b B, zx_fc_codes_denorm_tl T where B.CLASSIFICATION_CODES_DENORM_ID = T.CLASSIFICATION_CODES_DENORM_ID and T.LANGUAGE = userenv('LANG')