1. Tables and Views for SCM
  2. MSC_AP_CATEGORY_SETS_V

MSC_AP_CATEGORY_SETS_V

Details

  • Schema: FUSION

  • Object owner: MSC

  • Object type: VIEW

Columns

Name

SR_CATEGORY_SET_ID

CATEGORY_SET_NAME

DESCRIPTION

CONTROL_LEVEL

DEFAULT_FLAG

START_DATE

END_DATE

LAST_UPDATE_DATE

LAST_UPDATED_BY

CREATION_DATE

CREATED_BY

Query

SQL_Statement

SELECT

ecs.CATEGORY_SET_ID SR_CATEGORY_SET_ID,

ecs.CATEGORY_SET_NAME,

ecs.DESCRIPTION,

ecs.CONTROL_LEVEL,

DECODE( eds.Category_Set_ID, NULL, 2, 1) Default_Flag,

trunc(ecs.START_DATE) START_DATE,

trunc(ecs.END_DATE) END_DATE,

ecs.LAST_UPDATE_DATE,

ecs.LAST_UPDATED_BY,

ecs.CREATION_DATE,

ecs.CREATED_BY

FROM egp_category_sets_vl ecs,

EGP_DEFAULT_CATEGORY_SETS eds

WHERE eds.Category_Set_ID(+) = ecs.Category_Set_ID

AND MULT_ITEM_CAT_ASSIGN_FLAG != 'Y'

AND CONTROL_LEVEL IN (1)

AND CATALOG_CONTENT_CODE = 'LEAF_ITEMS'

AND eds.FUNCTIONAL_AREA_ID(+) = 3