APPS.MSC_HORIZONTAL_PLAN_SC dependencies on MSC_TRADING_PARTNERS

Line 309: msc_trading_partners tp

305: -- -------------------------------------------------
306: CURSOR bucket_dates(p_start_date DATE, p_end_date DATE) IS
307: SELECT cal.calendar_date
308: FROM msc_calendar_dates cal,
309: msc_trading_partners tp
310: WHERE tp.sr_tp_id = arg_plan_organization_id
311: AND tp.sr_instance_id = arg_plan_instance_id
312: AND tp.calendar_exception_set_id = cal.exception_set_id
313: AND tp.partner_type = 3

Line 413: msc_trading_partners param,

409: SUM(NVL(rec.old_order_quantity,0)) old_quantity,
410: sum(0) dos,
411: 0 cost
412: FROM msc_form_query list,
413: msc_trading_partners param,
414: msc_system_items msi,
415: msc_supplies rec,
416: msc_calendar_dates dates
417: WHERE (arg_res_level = 1

Line 603: msc_trading_partners param,

599: 0 old_quantity,
600: 0 dos,
601: 0 cost
602: FROM msc_form_query list,
603: msc_trading_partners param,
604: msc_demands mgr,
605: msc_calendar_dates dates
606: WHERE (arg_res_level = 1
607: OR (arg_res_level = 2

Line 739: msc_trading_partners param,

735: SUM (NVL(mgr.using_requirement_quantity, 1))) old_quantity,
736: 0 dos,
737: 0 cost
738: FROM msc_form_query list,
739: msc_trading_partners param,
740: msc_demands mgr,
741: msc_calendar_dates dates
742: WHERE (arg_res_level = 1
743: OR (arg_res_level = 2