APPS.GMP_HORIZONTAL_PDR_PKG dependencies on MSC_DEMANDS

Line 201: -- MSC_DEMANDS and MSC_SUPPLIES

197:
198:
199: -- --------------------------------------------
200: -- This cursor selects the snapshot activity in
201: -- MSC_DEMANDS and MSC_SUPPLIES
202: -- for the items per organizatio for a plan..
203: -- --------------------------------------------
204: CURSOR mrp_snapshot_activity IS
205: SELECT /*+ INDEX(rec, MSC_SUPPLIES_N1) */

Line 442: msc_demands mgr,

438: 0 cost
439: FROM -- msc_form_query list,
440: gmp_pdr_items_gtmp gpi,
441: msc_trading_partners param,
442: msc_demands mgr,
443: msc_calendar_dates dates
444: WHERE /*(arg_res_level = 1
445: OR (arg_res_level = 2
446: AND mgr.project_id is NULL)

Line 574: msc_demands mgr,

570: 0 cost
571: FROM --msc_form_query list,
572: gmp_pdr_items_gtmp gpi,
573: msc_trading_partners param,
574: msc_demands mgr,
575: msc_calendar_dates dates
576: WHERE /*(arg_res_level = 1
577: OR (arg_res_level = 2
578: AND mgr.project_id is NULL)