APPS.GMP_HORIZONTAL_PDR_PKG dependencies on MSC_SUPPLIES

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 217: SELECT /*+ INDEX(rec, MSC_SUPPLIES_N1) */

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) */
218: /* list.number5 item_id,
219: list.number6 org_id,
220: list.number3 inst_id,
221: */

Line 276: msc_supplies rec,

272: FROM --msc_form_query list,
273: gmp_pdr_items_gtmp gpi,
274: msc_trading_partners param,
275: -- msc_system_items msi,
276: msc_supplies rec,
277: msc_calendar_dates dates
278: WHERE /*(arg_res_level = 1
279: OR (arg_res_level = 2
280: AND rec.project_id is NULL)

Line 490: from msc_supplies mr

486: AND param.partner_type = 3
487: --AND list.query_id = item_list_id
488: AND not exists (
489: select 'cancelled IR'
490: from msc_supplies mr
491: where mgr.origination_type in (30,6)
492: and mgr.disposition_id = mr.transaction_id
493: and mr.plan_id = G_plan_id --Added instance id as per bug # 12573284 to improve performance
494: and mgr.plan_id = mr.plan_id