[Home] [Help]
168: decode(sup.firm_date, null, sup.new_ship_date , null), --ship_date
169: decode(sup.firm_date,null,nvl(sup.new_dock_date,msc_calendar.DATE_OFFSET(sup.organization_id, sup.sr_instance_id, 1, sup.new_schedule_date, - nvl(i.postprocessing_lead_time,0))),
170: msc_calendar.DATE_OFFSET(sup.organization_id,sup.sr_instance_id, 1,sup.firm_date, - nvl(i.postprocessing_lead_time,0))
171: ) --reciept_date
172: from msc_plan_organizations_v ov,
173: msc_system_items i,
174: msc_supplies sup,
175: msc_plan_buckets mpb
176: where ov.plan_id = p_plan_id and
268: decode(sup.firm_date, null, sup.new_ship_date , null), --ship_date
269: decode(sup.firm_date,null,nvl(sup.new_dock_date,msc_calendar.DATE_OFFSET(sup.organization_id, sup.sr_instance_id, 1, sup.new_schedule_date, - nvl(i.postprocessing_lead_time,0))),
270: msc_calendar.DATE_OFFSET(sup.organization_id,sup.sr_instance_id, 1,sup.firm_date, - nvl(i.postprocessing_lead_time,0))
271: ) --reciept_date
272: from msc_plan_organizations_v ov,
273: msc_system_items i,
274: msc_supplies sup,
275: msc_trading_partners t1,
276: msc_plan_buckets mpb
411: ), --reciept_date
412: -- order_number => order number for intransit shipment, NULL for Expected inbound shipment
413: sup.order_number order_number, -- use only for intransit_shipment_def and intransit_receipt_def
414: NULL line_number -- dummy type not to be used
415: from msc_plan_organizations_v ov,
416: msc_system_items i,
417: msc_supplies sup,
418: msc_trading_partners t1,
419: msc_plan_buckets mpb
516: dem.schedule_arrival_date, --reciept_date
517: -- Order_number =>
518: decode(instr(dem.order_number,'.'), 0 , dem.order_number, substr(dem.order_number,1,instr(dem.order_number,'.')-1 )),--
519: TRIM(decode(instr(dem.order_number,'(',-1,1),0,null,substr(dem.order_number,instr(dem.order_number,'(',-1,1) + 1,instr(dem.order_number,')',-1,1) - instr(dem.order_number,'(',-1,1) -1 ))) --
520: from msc_plan_organizations_v ov,
521: msc_system_items i,
522: msc_demands dem,
523: msc_trading_partners t1,
524: msc_plan_buckets mpb
5106: RETURNS_FORECAST,DEFECTIVE_OUTBOUND_SHIPMENT) and -- bug#6893383
5107: sd.plan_id = -1 and
5108: sd.publisher_id = 1 and
5109: exists (select cs.company_site_id
5110: from msc_plan_organizations o,
5111: msc_company_sites cs,
5112: msc_trading_partner_maps m,
5113: msc_trading_partners p
5114: where o.plan_id = p_plan_id
5125: sd.supplier_id = nvl(l_supplier_id, sd.supplier_id) and
5126: sd.supplier_site_id = nvl(l_supplier_site_id, sd.supplier_site_id) and
5127: exists (select nvl(i.base_item_id,i.inventory_item_id)
5128: from msc_system_items i,
5129: msc_plan_organizations o
5130: where o.plan_id = p_plan_id and
5131: i.plan_id = o.plan_id and
5132: O.ORGANIZATION_ID = NVL(p_org_id , O.ORGANIZATION_ID) AND
5133: O.SR_INSTANCE_ID = NVL(p_sr_instance_id , O.SR_INSTANCE_ID) AND
5152: RETURNS_FORECAST,DEFECTIVE_OUTBOUND_SHIPMENT) and -- bug#6893383
5153: sd.plan_id = -1 and
5154: sd.publisher_id = 1 and
5155: exists (select cs.company_site_id
5156: from msc_plan_organizations o,
5157: msc_company_sites cs,
5158: msc_trading_partner_maps m,
5159: msc_trading_partners p
5160: where o.plan_id = p_plan_id and
5171: sd.supplier_id = nvl(l_supplier_id, sd.supplier_id) and
5172: sd.supplier_site_id = nvl(l_supplier_site_id, sd.supplier_site_id) and
5173: exists (select nvl(i.base_item_id,i.inventory_item_id)
5174: from msc_system_items i,
5175: msc_plan_organizations o
5176: where o.plan_id = p_plan_id and
5177: i.plan_id = o.plan_id and
5178: i.organization_id = nvl(p_org_id,
5179: o.organization_id) and