612: DesigType,
613: FcstShipTo
614: FROM
615: msc_designators desig,
616: fnd_lookups lu
617: WHERE
618: ( (desig.designator_type = 6 and desig.forecast_set_id is null) OR
619: (desig.designator_type in (5,8)) ) AND
620: trunc(nvl(desig.disable_date, trunc(sysdate) + 1)) > trunc(sysdate) AND
640: decode(desig.designator_type, 6, desig.update_type, -1)
641: FROM
642: msc_designators desig,
643: msc_plan_organizations_v mpo,
644: fnd_lookups lu
645: WHERE
646: ( (desig.designator_type = 6 AND desig.forecast_set_id is null) OR
647: (desig.designator_type in (5,8)) ) AND
648: trunc(nvl(desig.disable_date, trunc(sysdate) + 1)) > trunc(sysdate) AND
662: FROM
663: msc_designators desig,
664: msc_item_sourcing mis,
665: msc_plans mp,
666: fnd_lookups lu
667: WHERE
668: ( (desig.designator_type = 6 AND desig.forecast_set_id is null) OR
669: (desig.designator_type IN (5,8)) ) AND
670: trunc(nvl(desig.disable_date, trunc(sysdate) + 1)) > trunc(sysdate) AND