1. Tables and Views for SCM
  2. MSS_ON_HOLD_INVENTORY_LOTS_V

MSS_ON_HOLD_INVENTORY_LOTS_V

Details

  • Schema: FUSION

  • Object owner: MSS

  • Object type: VIEW

Columns

Name

PLAN_ID

INVENTORY_ITEM_ID

LOT_NUMBER

ITEM_CODE

DESCRIPTION

ON_HOLD_QUANTITY

UOM_CODE

UOM_NAME

HOLD_DATE

CREATED_BY

CREATION_DATE

LAST_UPDATED_BY

LAST_UPDATE_DATE

LAST_UPDATE_LOGIN

Query

SQL_Statement

select

lot.PLAN_ID,

lot.INVENTORY_ITEM_ID,

lot.LOT_NUMBER,

item.ITEM_CODE,

item.DESCRIPTION,

lot.QUANTITY ON_HOLD_QUANTITY,

item.UOM_CODE,

item.UOM_NAME,

lot.HOLD_DATE,

lot.CREATED_BY,

lot.CREATION_DATE,

lot.LAST_UPDATED_BY,

lot.LAST_UPDATE_DATE,

lot.LAST_UPDATE_LOGIN

from MSS_INVENTORY_LOTS lot

join MSS_PLAN_DEFINITIONS plan

on lot.PLAN_ID = plan.PLAN_ID and lot.HOLD_DATE >= plan.HORIZON_START_DATE

join MSS_ITEMS item

on item.PLAN_ID=lot.PLAN_ID and item.INVENTORY_ITEM_ID=lot.INVENTORY_ITEM_ID