BEN_BNFT_CATEGORY_VL

Details

• Schema: FUSION

• Object owner: BEN

• Object type: VIEW

Columns

Name

CATEGORY_CD USAGE_CD USER_NAME ACTIVE_FLAG LEGAL_ENTITY_ID BUSINESS_GROUP_ID CREATED_BY CREATION_DATE LAST_UPDATED_BY LAST_UPDATE_DATE LAST_UPDATE_LOGIN OBJECT_VERSION_NUMBER CATEGORY_HELP_TEXT PRMRY_RT_LABEL DSPLY_ANN_PRMRY_RT SCNDRY_RT_LABEL DSPLY_SCNDRY_RT OTHR_PRETAX_RT_LABEL DSPLY_OTHR_PRETAX_RT OTHR_AFTERTAX_RT_LABEL DSPLY_OTHR_AFTERTAX_RT OTHR_TAXABLE_RT_LABEL DSPLY_OTHR_TAXABLE_RT OTHR_NONTAX_RT_LABEL DSPLY_OTHR_NONTAX_RT OTHR_NOTAPPLICABLE_RT_LABEL DSPLY_OTHR_NOTAPPLICABLE_RT COVERAGE_LABEL DSPLY_COVERAGE LABEL1 LABEL2 LABEL3 LABEL4 LABEL5 LABEL6 CONFIG_NUM_1 CONFIG_NUM_2 CONFIG_NUM_3 CONFIG_NUM_4 CONFIG_NUM_5 CONFIG_CHAR_1 CONFIG_CHAR_2 CONFIG_CHAR_3 CONFIG_CHAR_4 CONFIG_CHAR_5 CONFIG_DATE_1 CONFIG_DATE_2 CONFIG_DATE_3 CONFIG_DATE_4 CONFIG_DATE_5 SEED_DATA_SOURCE

Query

SQL_Statement

SELECT BNFT.CATEGORY_CD, BNFT.USAGE_CD, NVL(TL.USER_NAME, BNFT.USER_NAME) USER_NAME, BNFT.ACTIVE_FLAG, BNFT.LEGAL_ENTITY_ID, BNFT.BUSINESS_GROUP_ID, BNFT.CREATED_BY, BNFT.CREATION_DATE, BNFT.LAST_UPDATED_BY, BNFT.LAST_UPDATE_DATE, BNFT.LAST_UPDATE_LOGIN, BNFT.OBJECT_VERSION_NUMBER, BNFT.CATEGORY_HELP_TEXT, NVL(TL.PRMRY_RT_LABEL, BNFT.PRMRY_RT_LABEL) PRMRY_RT_LABEL, BNFT.DSPLY_ANN_PRMRY_RT, NVL(TL.SCNDRY_RT_LABEL, BNFT.SCNDRY_RT_LABEL) SCNDRY_RT_LABEL, BNFT.DSPLY_SCNDRY_RT, NVL(TL.OTHR_PRETAX_RT_LABEL, BNFT.OTHR_PRETAX_RT_LABEL) OTHR_PRETAX_RT_LABEL, BNFT.DSPLY_OTHR_PRETAX_RT, NVL(TL.OTHR_AFTERTAX_RT_LABEL, BNFT.OTHR_AFTERTAX_RT_LABEL) OTHR_AFTERTAX_RT_LABEL, BNFT.DSPLY_OTHR_AFTERTAX_RT, NVL(TL.OTHR_TAXABLE_RT_LABEL, BNFT.OTHR_TAXABLE_RT_LABEL) OTHR_TAXABLE_RT_LABEL, BNFT.DSPLY_OTHR_TAXABLE_RT, NVL(TL.OTHR_NONTAX_RT_LABEL, BNFT.OTHR_NONTAX_RT_LABEL) OTHR_NONTAX_RT_LABEL, BNFT.DSPLY_OTHR_NONTAX_RT, NVL(TL.OTHR_NOTAPPLICABLE_RT_LABEL, BNFT.OTHR_NOTAPPLICABLE_RT_LABEL) OTHR_NOTAPPLICABLE_RT_LABEL, BNFT.DSPLY_OTHR_NOTAPPLICABLE_RT, BNFT.COVERAGE_LABEL, BNFT.DSPLY_COVERAGE, BNFT.LABEL1, BNFT.LABEL2, BNFT.LABEL3, BNFT.LABEL4, BNFT.LABEL5, BNFT.LABEL6, BNFT.CONFIG_NUM_1, BNFT.CONFIG_NUM_2, BNFT.CONFIG_NUM_3, BNFT.CONFIG_NUM_4, BNFT.CONFIG_NUM_5, BNFT.CONFIG_CHAR_1, BNFT.CONFIG_CHAR_2, BNFT.CONFIG_CHAR_3, BNFT.CONFIG_CHAR_4, BNFT.CONFIG_CHAR_5, BNFT.CONFIG_DATE_1, BNFT.CONFIG_DATE_2, BNFT.CONFIG_DATE_3, BNFT.CONFIG_DATE_4, BNFT.CONFIG_DATE_5, BNFT.SEED_DATA_SOURCE FROM BEN_BNFT_CATEGORY BNFT, BEN_BNFT_CATEGORY_TL TL WHERE BNFT.CATEGORY_CD = TL.CATEGORY_CD(+) AND BNFT.USAGE_CD = TL.USAGE_CD(+) AND TL.LANGUAGE(+) = USERENV('LANG')