DBA Data[Home] [Help]

APPS.MSC_WS_DRP dependencies on FND_LOOKUPS

Line 616: fnd_lookups lu

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

Line 644: fnd_lookups lu

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

Line 666: fnd_lookups lu

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