Planned order demand
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,