APPS.GMP_HORIZONTAL_PDR_PKG dependencies on MSC_SUPPLIES

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

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) */
206: /* list.number5 item_id,
207: list.number6 org_id,
208: list.number3 inst_id,
209: */

Line 264: msc_supplies rec,

260: FROM --msc_form_query list,
261: gmp_pdr_items_gtmp gpi,
262: msc_trading_partners param,
263: -- msc_system_items msi,
264: msc_supplies rec,
265: msc_calendar_dates dates
266: WHERE /*(arg_res_level = 1
267: OR (arg_res_level = 2
268: AND rec.project_id is NULL)

Line 478: from msc_supplies mr

474: AND param.partner_type = 3
475: --AND list.query_id = item_list_id
476: AND not exists (
477: select 'cancelled IR'
478: from msc_supplies mr
479: where mgr.origination_type in (30,6)
480: and mgr.disposition_id = mr.transaction_id
481: and mgr.plan_id = mr.plan_id
482: and mgr.sr_instance_id = mr.sr_instance_id