DBA Data[Home] [Help]

APPS.MSC_SUPPLIER_HORIZONTAL_PLAN dependencies on MSC_CALENDAR_DATES

Line 79: msc_calendar_dates cal,

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

Line 239: msc_calendar_dates cal

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