BEN_ELCN_RULES_VL

Details

• Schema: FUSION

• Object owner: BEN

• Object type: VIEW

Columns

Name

BEN_ELCN_RULE_ID PL_TYP_GRP_CD NAME DESCRIPTION PGM_ID PL_ID OIPL_ID OPT_ID RULE_TYPE MUST_OIPL_ID MUST_PL_ID MUST_OPT_ID MUST_PGM_ID SCOPE MSG_TEXT STAT_CD CREATED_BY CREATION_DATE LAST_UPDATED_BY LAST_UPDATE_DATE LAST_UPDATE_LOGIN OBJECT_VERSION_NUMBER BUSINESS_GROUP_ID INFO_CHAR_1 INFO_CHAR_2 INFO_CHAR_3 INFO_CHAR_4 INFO_CHAR_5 INFO_CHAR_6 INFO_CHAR_7 INFO_CHAR_8 INFO_CHAR_9 INFO_CHAR_10 INFO_DATE_1 INFO_DATE_2 INFO_DATE_3 INFO_DATE_4 INFO_DATE_5 INFO_NUM_1 INFO_NUM_2 INFO_NUM_3 INFO_NUM_4 INFO_NUM_5

Query

SQL_Statement

SELECT ELCN.BEN_ELCN_RULE_ID, ELCN.PL_TYP_GRP_CD, ELCN.NAME, ELCN.DESCRIPTION, ELCN.PGM_ID, ELCN.PL_ID, ELCN.OIPL_ID, ELCN.OPT_ID, ELCN.RULE_TYPE, ELCN.MUST_OIPL_ID, ELCN.MUST_PL_ID, ELCN.MUST_OPT_ID, ELCN.MUST_PGM_ID, ELCN.SCOPE, NVL(TL.MSG_TEXT, ELCN.MSG_TEXT) MSG_TEXT, ELCN.STAT_CD, ELCN.CREATED_BY, ELCN.CREATION_DATE, ELCN.LAST_UPDATED_BY, ELCN.LAST_UPDATE_DATE, ELCN.LAST_UPDATE_LOGIN, ELCN.OBJECT_VERSION_NUMBER, ELCN.BUSINESS_GROUP_ID, ELCN.INFO_CHAR_1, ELCN.INFO_CHAR_2, ELCN.INFO_CHAR_3, ELCN.INFO_CHAR_4, ELCN.INFO_CHAR_5, ELCN.INFO_CHAR_6, ELCN.INFO_CHAR_7, ELCN.INFO_CHAR_8, ELCN.INFO_CHAR_9, ELCN.INFO_CHAR_10, ELCN.INFO_DATE_1, ELCN.INFO_DATE_2, ELCN.INFO_DATE_3, ELCN.INFO_DATE_4, ELCN.INFO_DATE_5, ELCN.INFO_NUM_1, ELCN.INFO_NUM_2, ELCN.INFO_NUM_3, ELCN.INFO_NUM_4, ELCN.INFO_NUM_5 FROM BEN_ELCN_RULES ELCN ,BEN_ELCN_RULES_TL TL WHERE ELCN.BEN_ELCN_RULE_ID = TL.BEN_ELCN_RULE_ID (+) AND TL.LANGUAGE (+) = USERENV('LANG')