MSC_AP_MRSL_RULES_V

Details

  • Schema: FUSION

  • Object owner: MSC

  • Object type: VIEW

Columns

Name

MRSL_RULE_ID

MRSL_RULE_NAME

DESCRIPTION

CATEGORY_SET_ID

CATEGORY_SET_NAME

DEMAND_ANCHOR_DATE_TYPE

Query

SQL_Statement

SELECT

mrsl.mrsl_rule_id,

mrsl.mrsl_rule_name,

mrsl.description,

mrsl.category_set_id,

cat.category_set_name,

mrsl.demand_anchor_date_type

FROM MSC_SRC_MRSL_RULES_VL mrsl,

EGP_CATEGORY_SETS_VL cat

WHERE cat.category_set_id(+) = mrsl.category_set_id