DBA Data[Home] [Help]

APPS.MSC_WS_ASCP dependencies on MSC_PLAN_ORGANIZATIONS_V

Line 834: msc_plan_organizations_v mpo

830: decode(desig.designator_type, 6, desig.update_type, -1)
831: FROM
832: msc_designators desig,
833: fnd_lookups lu,
834: msc_plan_organizations_v mpo
835: WHERE
836: ( (desig.designator_type = 6 AND desig.forecast_set_id is null) OR
837: (desig.designator_type IN (2,3,4,5,8))
838: ) AND

Line 1026: msc_plan_organizations_v mpo

1022: SELECT
1023: desig.designator_type
1024: FROM
1025: msc_designators desig,
1026: msc_plan_organizations_v mpo
1027: WHERE
1028: desig.designator_type not in (1,6,7,8) AND
1029: trunc(nvl(desig.disable_date, trunc(sysdate) + 1)) > trunc(sysdate) AND
1030: mpo.organization_id = desig.organization_id AND