JMF_IN_RULES_VL
Details
-
Schema: FUSION
-
Object owner: JMF
-
Object type: VIEW
Columns
Name |
---|
RULE_SET_CODE RULE_TYPE ESTABLISHMENT_ID CATEGORY_SET_ID LANGUAGE RULE_SET_DESC SOURCE_LANG LAST_UPDATED_BY CREATION_DATE LAST_UPDATE_LOGIN LAST_UPDATE_DATE CREATED_BY OBJECT_VERSION_NUMBER SEEDED_FLAG |
Query
SQL_Statement |
---|
SELECT B.RULE_SET_CODE, B.RULE_TYPE, B.ESTABLISHMENT_ID, B.CATEGORY_SET_ID, T.LANGUAGE, T.RULE_SET_DESC, T.SOURCE_LANG, B.LAST_UPDATED_BY, B.CREATION_DATE, B.LAST_UPDATE_LOGIN, B.LAST_UPDATE_DATE, B.CREATED_BY, B.OBJECT_VERSION_NUMBER, B.SEEDED_FLAG FROM JMF_IN_RULES_B B, JMF_IN_RULES_TL T WHERE B.RULE_SET_CODE = T.RULE_SET_CODE AND T.LANGUAGE = USERENV('LANG') |