APPS.GMP_HORIZONTAL_PDR_PKG dependencies on MSC_TRADING_PARTNERS

Line 153: msc_trading_partners mtp

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

Line 179: msc_trading_partners tp

175: -- -------------------------------------------------
176: CURSOR bucket_dates(p_start_date DATE, p_end_date DATE) IS
177: SELECT cal.calendar_date
178: FROM msc_calendar_dates cal,
179: msc_trading_partners tp
180: WHERE tp.sr_tp_id = G_org_id
181: AND tp.sr_instance_id = G_inst_id
182: AND tp.calendar_exception_set_id = cal.exception_set_id
183: AND tp.partner_type = 3

Line 262: msc_trading_partners param,

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

Line 441: msc_trading_partners param,

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

Line 573: msc_trading_partners param,

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