Value Chain Planning - EBS (MOSC)

MOSC Banner

Planned order demand

edited Sep 23, 2018 5:04AM in Value Chain Planning - EBS (MOSC) 1 commentAnswered

Hi

Can some one help me with my query

select a.ORDER_TYPE_TEXT

      ,a.QUANTITY_RATE

      ,trunc(a.NEW_ORDER_DATE)NEW_DUE_DATE

      ,trunc(a.NEW_DUE_DATE)NEED_BY_DATE

      ,trunc(a.NEW_DUE_DATE) - ssi.FIXED_LEAD_TIME ss_date

      ,trunc(a.FIRM_DATE)FIRM_DATE

      ,msi.segment1||'.'||msi.segment2   Full_Code

      ,msi.description ITEM_NAME

      ,ssi.INVENTORY_ITEM_ID

      ,ssi.FIXED_LEAD_TIME

      ,msi.ITEM_TYPE

      ,a.CATEGORY_NAME

      ,a.action

      ,a.ORDER_NUMBER   

      ,a.USING_ASSEMBLY_SEGMENTS 

      ,d.order_number  

      ,s.WIP_START_QUANTITY

      ,p.DEMAND_QUANTITY                               

from msc_orders_v a,

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