1. Tables and Views for SCM
  2. MSS_EGP_ITEM_CATEGORIES_VL

MSS_EGP_ITEM_CATEGORIES_VL

Details

  • Schema: FUSION

  • Object owner: MSS

  • Object type: VIEW

Columns

Name

ORGANIZATION_ID

INVENTORY_ITEM_ID

ITEM_NUMBER

DESCRIPTION

PRIMARY_UOM_CODE

PLANNING_MAKE_BUY_CODE

CATEGORY_ID

CATEGORY_SET_ID

Query

SQL_Statement

Select

item.ORGANIZATION_ID,

item.INVENTORY_ITEM_ID,

item.ITEM_NUMBER,

item.DESCRIPTION,

item.PRIMARY_UOM_CODE,

item.PLANNING_MAKE_BUY_CODE,

itCat.CATEGORY_ID,

itCat.CATEGORY_SET_ID

from

EGP_SYSTEM_ITEMS_VL item

join INV_ORG_PARAMETERS orgParam on

item.ORGANIZATION_ID = orgParam.ORGANIZATION_ID

join EGP_ITEM_CAT_ASSIGNMENTS itCat on

orgParam.MASTER_ORGANIZATION_ID = itCat.ORGANIZATION_ID and item.INVENTORY_ITEM_ID = itCat.INVENTORY_ITEM_ID