APPS.GMP_HORIZONTAL_PDR_PKG dependencies on MSC_TRADING_PARTNERS

Line 154: msc_trading_partners mtp

150: -- Vpedarla Bug:7257708 Modified the cursor. corrected the mistake done for bug: 6784251
151: CURSOR cur_bckt_end_date IS
152: SELECT MIN(trunc(mpsd.next_date))
153: FROM msc_period_start_dates mpsd,
154: msc_trading_partners mtp
155: WHERE
156: mtp.calendar_code = mpsd.calendar_code
157: AND mtp.calendar_exception_set_id = mpsd.exception_set_id
158: AND mtp.sr_tp_id = G_org_id

Line 184: msc_trading_partners tp

180: -- -------------------------------------------------
181: CURSOR bucket_dates(p_start_date DATE, p_end_date DATE) IS
182: SELECT cal.calendar_date
183: FROM msc_calendar_dates cal,
184: msc_trading_partners tp
185: WHERE tp.sr_tp_id = G_org_id
186: AND tp.sr_instance_id = G_inst_id
187: AND tp.calendar_exception_set_id = cal.exception_set_id
188: AND tp.partner_type = 3

Line 274: msc_trading_partners param,

270: sum(0) dos,
271: 0 cost
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

Line 452: msc_trading_partners param,

448: 0 dos,
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

Line 586: msc_trading_partners param,

582: 0 dos,
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