APPS.MSC_SUPPLIER_HORIZONTAL_PLAN dependencies on MSC_TRADING_PARTNERS

Line 78: msc_trading_partners mtp,

74: cal.calendar_date,
75: null,
76: cap.capacity
77: FROM
78: msc_trading_partners mtp,
79: msc_calendar_dates cal,
80: msc_supplier_capacities cap,
81: msc_item_suppliers items,
82: msc_form_query list

Line 238: FROM msc_trading_partners tp,

234: WHERE plan_id = g_designator;
235:
236: CURSOR bucket_dates(p_start_date DATE, p_end_date DATE) IS
237: SELECT cal.calendar_date
238: FROM msc_trading_partners tp,
239: msc_calendar_dates cal
240: WHERE tp.sr_tp_id = g_org_id
241: AND tp.sr_instance_id = g_inst_id
242: AND tp.calendar_exception_set_id = cal.exception_set_id

Line 472: FROM msc_trading_partners

468:
469: g_error_stmt := 'Debug - flush_crp_plan - 5';
470: SELECT partner_name
471: INTO v_supplier_name
472: FROM msc_trading_partners
473: WHERE partner_id = p_sup_id;
474:
475: SELECT item_name
476: INTO v_item_name