[Home] [Help]
409: to_number(null) buy_order_value,
410: to_number(null) buy_order_value2,
411: to_number(null) buy_order_count
412: from
413: msc_bis_inv_detail mbid,
414: msc_trading_partners mtp
415: where mbid.plan_id = p_plan_id
416: and mbid.supplier_id is not null
417: and mbid.organization_id = mtp.sr_tp_id
437: nvl(ms.supplier_site_id, -23453) supplier_site_id, -- supplier_site_id for SNO
438: ms.inventory_item_id inventory_item_id,
439: mtp.currency_code,
440: trunc(ms.new_schedule_date) analysis_date, -- new_schedule_date for SNO
441: to_number(null) required_qty, -- msc_bis_inv_detail.supplier_usage
442: to_number(null) avail_qty, -- msc_bis_inv_detail.supplier_capacity
443: to_number(null) po_reschedule_count, -- 0 for SNO
444: sum(decode(ms.order_type, 1, 1, 0)) po_count,
445: to_number(null), -- 0 for SNO
438: ms.inventory_item_id inventory_item_id,
439: mtp.currency_code,
440: trunc(ms.new_schedule_date) analysis_date, -- new_schedule_date for SNO
441: to_number(null) required_qty, -- msc_bis_inv_detail.supplier_usage
442: to_number(null) avail_qty, -- msc_bis_inv_detail.supplier_capacity
443: to_number(null) po_reschedule_count, -- 0 for SNO
444: sum(decode(ms.order_type, 1, 1, 0)) po_count,
445: to_number(null), -- 0 for SNO
446:
855: last_value(mbid.pab ignore nulls) over (partition by mbid.plan_id, mbid.sr_instance_id,
856: mbid.organization_id, mbid.inventory_item_id, mbid.ship_method
857: order by mbid.detail_date) inv_build_target
858: -- wei: SNO meassure, to add include partition by vmi.number6 order by map.date2
859: from msc_bis_inv_detail mbid,
860: msc_trading_partners bis_mtp
861: where nvl(mbid.detail_level,0)=1
862: and nvl(mbid.period_type,0)=1
863: and mbid.plan_id=p_plan_id