Product: | EGO - Advanced Product Catalog |
---|---|
Description: | this view contains the rule metadata |
Implementation/DBA Data: | APPS.EGO_USER_RULES_VL |
SELECT B.ROWID ROW_ID
, B.RULE_ID RULE_ID
, B.RULESET_ID RULESET_ID
, B.SEQUENCE SEQUENCE
, B.RULE_NAME RULE_NAME
, B.ATTR_GROUP_TYPE ATTR_GROUP_TYPE
, B.ATTR_GROUP_NAME ATTR_GROUP_NAME
, B.ATTR_NAME ATTR_NAME
, B.SEVERITY SEVERITY
, B.RULE_XML RULE_XML
, B.LAST_UPDATE_DATE LAST_UPDATE_DATE
, B.LAST_UPDATED_BY LAST_UPDATED_BY
, B.CREATION_DATE CREATION_DATE
, B.CREATED_BY CREATED_BY
, B.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, T.DESCRIPTION DESCRIPTION
, T.USER_EXPLANATION_MESSAGE USER_EXPLANATION_MESSAGE
FROM EGO_USER_RULES_TL T
, EGO_USER_RULES_B B
WHERE B.RULE_ID = T.RULE_ID
AND T.LANGUAGE = USERENV('LANG')