1. Tables and Views for SCM
  2. MSC_SRC_MRSL_RULES_VL

MSC_SRC_MRSL_RULES_VL

Details

  • Schema: FUSION

  • Object owner: MSC

  • Object type: VIEW

Columns

Name

MRSL_RULE_ID

MRSL_RULE_NAME

DESCRIPTION

CATEGORY_SET_ID

DEMAND_ANCHOR_DATE_TYPE

OBJECT_VERSION_NUMBER

REFRESH_NUMBER

CREATED_BY

CREATION_DATE

LAST_UPDATED_BY

LAST_UPDATE_DATE

LAST_UPDATE_LOGIN

LOAD_REQUEST_ID

Query

SQL_Statement

SELECT

b.mrsl_rule_id,

tl.mrsl_rule_name,

tl.description,

b.category_set_id,

b.demand_anchor_date_type,

b.object_version_number,

b.refresh_number,

b.created_by,

b.creation_date,

b.last_updated_by,

b.last_update_date,

b.last_update_login,

b.load_request_id

FROM msc_src_mrsl_rules_b b, msc_src_mrsl_rules_tl tl

WHERE b.mrsl_rule_id = tl.mrsl_rule_id

AND tl.LANGUAGE = USERENV('LANG')