1. Tables and Views for SCM
  2. JMF_IN_RULES_VL

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')