1. Tables and Views for SCM
  2. MSC_CATEGORY_SETS_V

MSC_CATEGORY_SETS_V

Details

  • Schema: FUSION

  • Object owner: MSC

  • Object type: VIEW

Columns

Name

CATEGORY_SET_ID

CATEGORY_SET_NAME

CONTROL_LEVEL

DEFAULT_FLAG

LAST_UPDATE_DATE

LAST_UPDATED_BY

CREATION_DATE

CREATED_BY

Query

SQL_Statement

SELECT

ecs.CATEGORY_SET_ID,

ecs.CATEGORY_SET_NAME,

ecs.CONTROL_LEVEL,

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

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 eds.Functional_Area_ID(+)= 3