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
83: WHERE
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
243: AND tp.partner_type = 3