1. Tables and Views for SCM
  2. MSC_PLANNED_EGP_SYSTEM_ITEMS_V

MSC_PLANNED_EGP_SYSTEM_ITEMS_V

Details

  • Schema: FUSION

  • Object owner: FUSION

  • Object type: VIEW

Columns

Name

INVENTORY_ITEM_ID

ITEM_NUMBER

ORGANIZATION_ID

ORGANIZATION_CODE

UOM_CODE

BOM_ITEM_TYPE

POSTPROCESSING_LEAD_TIME

SHRINKAGE_RATE

BASE_ITEM_ID

WIP_SUPPLY_TYPE

EFFECTIVITY_CONTROL

AUTO_CREATED_CONFIG_FLAG

OUTSIDE_PROCESS_SERVICE_FLAG

Query

SQL_Statement

SELECT

inventory_item_id ,

item_number ,

organization_id ,

organization_code ,

uom_code ,

bom_item_type ,

postprocessing_lead_time ,

shrinkage_rate ,

base_item_id ,

wip_supply_type ,

effectivity_control ,

auto_created_config_flag ,

outside_process_service_flag

FROM msc_planned_egp_system_items