APPS.MSC_HORIZONTAL_PLAN_SC dependencies on MSC_TRADING_PARTNERS

Line 280: msc_trading_partners tp

276: -- -------------------------------------------------
277: CURSOR bucket_dates(p_start_date DATE, p_end_date DATE) IS
278: SELECT cal.calendar_date
279: FROM msc_calendar_dates cal,
280: msc_trading_partners tp
281: WHERE tp.sr_tp_id = arg_plan_organization_id
282: AND tp.sr_instance_id = arg_plan_instance_id
283: AND tp.calendar_exception_set_id = cal.exception_set_id
284: AND tp.partner_type = 3

Line 368: msc_trading_partners param,

364: SUM(NVL(rec.old_order_quantity,0)) old_quantity,
365: sum(0) dos,
366: 0 cost
367: FROM msc_form_query list,
368: msc_trading_partners param,
369: msc_system_items msi,
370: msc_supplies rec,
371: msc_calendar_dates dates
372: WHERE (arg_res_level = 1

Line 534: msc_trading_partners param,

530: 0 old_quantity,
531: 0 dos,
532: 0 cost
533: FROM msc_form_query list,
534: msc_trading_partners param,
535: msc_demands mgr,
536: msc_calendar_dates dates
537: WHERE (arg_res_level = 1
538: OR (arg_res_level = 2

Line 661: msc_trading_partners param,

657: SUM (NVL(mgr.using_requirement_quantity, 1))) old_quantity,
658: 0 dos,
659: 0 cost
660: FROM msc_form_query list,
661: msc_trading_partners param,
662: msc_demands mgr,
663: msc_calendar_dates dates
664: WHERE (arg_res_level = 1
665: OR (arg_res_level = 2