DBA Data[Home] [Help]

APPS.GMP_HORIZONTAL_PDR_PKG dependencies on MSC_DEMANDS

Line 213: -- MSC_DEMANDS and MSC_SUPPLIES

209:
210:
211: -- --------------------------------------------
212: -- This cursor selects the snapshot activity in
213: -- MSC_DEMANDS and MSC_SUPPLIES
214: -- for the items per organizatio for a plan..
215: -- --------------------------------------------
216: CURSOR mrp_snapshot_activity IS
217: SELECT /*+ INDEX(rec, MSC_SUPPLIES_N1) */

Line 453: msc_demands mgr,

449: 0 cost
450: FROM -- msc_form_query list,
451: gmp_pdr_items_gtmp gpi,
452: msc_trading_partners param,
453: msc_demands mgr,
454: msc_calendar_dates dates
455: WHERE /*(arg_res_level = 1
456: OR (arg_res_level = 2
457: AND mgr.project_id is NULL)

Line 587: msc_demands mgr,

583: 0 cost
584: FROM --msc_form_query list,
585: gmp_pdr_items_gtmp gpi,
586: msc_trading_partners param,
587: msc_demands mgr,
588: msc_calendar_dates dates
589: WHERE /*(arg_res_level = 1
590: OR (arg_res_level = 2
591: AND mgr.project_id is NULL)