Product: | EGO - Advanced Product Catalog |
---|---|
Description: | this view contains the ruleset metadata |
Implementation/DBA Data: | APPS.EGO_RULE_SETS_VL |
SELECT B.ROWID ROW_ID
, B.RULESET_ID RULESET_ID
, B.RULESET_NAME RULESET_NAME
, B.RULESET_TYPE RULESET_TYPE
, B.COMPOSITE COMPOSITE
, B.ITEM_CATALOG_CATEGORY ITEM_CATALOG_CATEGORY
, B.ATTR_GROUP_TYPE ATTR_GROUP_TYPE
, B.ATTR_GROUP_NAME ATTR_GROUP_NAME
, 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.RULESET_DISPLAY_NAME RULESET_DISPLAY_NAME
, T.DESCRIPTION DESCRIPTION
FROM EGO_RULE_SETS_TL T
, EGO_RULE_SETS_B B
WHERE B.RULESET_ID = T.RULESET_ID
AND T.LANGUAGE = USERENV('LANG')