DBA Data[Home] [Help]

APPS.MSC_WS_SRP dependencies on FND_LOOKUPS

Line 745: fnd_lookups lu

741: DesigType,
742: FcstShipTo
743: FROM
744: msc_designators desig,
745: fnd_lookups lu
746: WHERE
747: ( (desig.designator_type = 6 AND desig.forecast_set_id is null) OR
748: (desig.designator_type IN (5,8)) ) AND
749: trunc(nvl(desig.disable_date, trunc(sysdate) + 1)) > trunc(sysdate) AND

Line 774: fnd_lookups lu

770: decode(desig.designator_type, 6, desig.update_type, -1)
771: FROM
772: msc_designators desig,
773: msc_plan_organizations_v mpo,
774: fnd_lookups lu
775: WHERE
776: ( (desig.designator_type = 6 AND desig.forecast_set_id IS NULL) OR
777: (desig.designator_type in (5,8)) ) AND
778: trunc(nvl(desig.disable_date, trunc(sysdate) + 1)) > trunc(sysdate) AND

Line 796: fnd_lookups lu

792: FROM
793: msc_designators desig,
794: msc_item_sourcing mis,
795: msc_plans mp,
796: fnd_lookups lu
797: WHERE
798: ( (desig.designator_type = 6 AND desig.forecast_set_id IS NULL) OR
799: (desig.designator_type IN (5,8)) ) AND
800: trunc(nvl(desig.disable_date, trunc(sysdate) + 1)) > trunc(sysdate) AND