MSS_ITEM_ON_HOLD_QUANTITIES_V

Details

• Schema: FUSION

• Object owner: MSS

• Object type: VIEW

Columns

Name
PLAN_ID INVENTORY_ITEM_ID ON_HOLD_QUANTITY

Query

SQL_Statement
select lot.PLAN_ID, lot.INVENTORY_ITEM_ID, sum(lot.QUANTITY) ON_HOLD_QUANTITY 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 group by lot.PLAN_ID, lot.INVENTORY_ITEM_ID