eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.MSC_GANTT_UTILS dependencies on MSC_SUPPLIER_CAPACITIES

Line 3944: msc_supplier_capacities msc,

3940: select mgq.row_index, mca.calendar_date, msc.capacity
3941: bulk collect into v_row_index, v_start_date, v_qty
3942: from msc_calendar_dates mca,
3943: msc_plans mp,
3944: msc_supplier_capacities msc,
3945: msc_item_suppliers mis,
3946: msc_gantt_query mgq
3947: where mgq.query_id = p_query_id
3948: and mgq.row_index = l_row_index

Line 3987: msc_supplier_capacities msc,

3983: select mgq.row_index, mfq.date1, msc.capacity
3984: bulk collect into v_row_index, v_start_date, v_qty
3985: from msc_form_query mfq,
3986: msc_plans mp,
3987: msc_supplier_capacities msc,
3988: msc_item_suppliers mis,
3989: msc_gantt_query mgq
3990: where mgq.query_id = p_query_id
3991: and mgq.row_index = l_row_index

Line 4101: msc_supplier_capacities msc1

4097: p_plan_end date) is
4098: select max(from_date) max_bkt_start_date,
4099: max(nvl(to_date,p_plan_end)) max_bkt_end_date
4100: from msc_gantt_query mgq,
4101: msc_supplier_capacities msc1
4102: where mgq.query_id = p_query
4103: and mgq.row_index = p_row_index
4104: and msc1.plan_id = p_plan
4105: and msc1.supplier_id = mgq.supplier_id