Value Chain Planning - EBS (MOSC)

MOSC Banner

Duplicate Legacy Sale order during launch daily plan (no duplicate in collection)

Example data

EOA : F91

TRS type : 0E297 ESS POLY SFSV-SPH GNSGYHCFG

OPC : 0054477294

Clo30 : 5547SZ1790H8000+0850C02+000


item:

5547SZ1790H8000+0850C02+000

—collection

select * FROM MSC_SALES_ORDERS
where inventory_ITEM_ID = 4104978
-- and plan_id = -1
and ORGANIZATION_ID = 4434
and SR_INSTANCE_ID = 1022
order by REQUIREMENT_DATE

DEMAND_ID

SR_INSTANCE_ID

INVENTORY_ITEM_ID

ORGANIZATION_ID

DEMAND_SOURCE_TYPE

DEMAND_SOURCE_HEADER_ID

DEMAND_SOURCE_LINE

DEMAND_SOURCE_DELIVERY

DEMAND_SOURCE_NAME

PRIMARY_UOM_QUANTITY

RESERVATION_TYPE

RESERVATION_QUANTITY

COMPLETED_QUANTITY

REQUIREMENT_DATE

SUBINVENTORY

DEMAND_CLASS

PARENT_DEMAND_ID

REFRESH_NUMBER

LAST_UPDATE_DATE

LAST_UPDATED_BY

CREATION_DATE

CREATED_BY

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center