1. Tables and Views for Sales and Fusion Service
  2. MOW_RULE_SET_GROUPS_VL

MOW_RULE_SET_GROUPS_VL

Details

  • Schema: FUSION

  • Object owner: MOW

  • Object type: VIEW

Columns

Name

RULE_SET_GROUP_GUID

WORKOBJ_CANDOBJ_REL_GUID

OWNER_MODULE

REF_ROW_GUID

RECORD_STATUS

DISPLAY_NAME

DESC_TEXT

CREATED_BY

CREATION_DATE

LAST_UPDATED_BY

LAST_UPDATE_DATE

LAST_UPDATE_LOGIN

OBJECT_VERSION_NUMBER

RULE_SET_GROUP_CODE

INACTIVE_FLAG

Query

SQL_Statement

SELECT

B.RULE_SET_GROUP_GUID,

B.WORKOBJ_CANDOBJ_REL_GUID,

B.OWNER_MODULE,

B.REF_ROW_GUID,

B.RECORD_STATUS,

T.DISPLAY_NAME,

T.DESC_TEXT,

B.CREATED_BY,

B.CREATION_DATE,

B.LAST_UPDATED_BY,

B.LAST_UPDATE_DATE,

B.LAST_UPDATE_LOGIN,

B.OBJECT_VERSION_NUMBER,

B.RULE_SET_GROUP_CODE,

B.INACTIVE_FLAG

FROM

MOW_RULE_SET_GROUPS_B B,

MOW_RULE_SET_GROUPS_TL T

WHERE B.RULE_SET_GROUP_GUID = T.RULE_SET_GROUP_GUID

AND T.LANGUAGE = USERENV('LANG')