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_CRP_HORIZONTAL_PLAN dependencies on MSC_NET_RESOURCE_AVAIL

Line 513: FROM msc_net_resource_avail avail,

509: to_date(NULL),
510: sum(avail.capacity_units * decode(from_time,NULL,1,(( DECODE(sign(avail.to_time-avail.from_time), -1, avail.to_time+86400, avail.to_time) - avail.from_time)/3600))),
511: to_number(-1),
512: to_char('-1')
513: FROM msc_net_resource_avail avail,
514:
515: msc_form_query list
516: WHERE trunc(avail.shift_date) <= trunc(g_cutoff_date)
517: AND avail.shift_date >= g_dates(1)+1

Line 527: AND not exists (select 'aggregate' from msc_net_resource_avail b

523: AND avail.resource_id = list.number3
524: AND avail.capacity_units >= 0
525: AND list.query_id = g_item_list_id
526: /*
527: AND not exists (select 'aggregate' from msc_net_resource_avail b
528: where b.shift_date = decode(v_agg_flag,1,null,avail.shift_date)
529: and b.resource_id = decode(v_agg_flag,1,null,avail.aggregate_resource_id)
530: and b.department_id = decode(v_agg_flag,1,null,avail.department_id)
531: and b.plan_id = avail.plan_id

Line 854: -- AND not exists (select 'aggregate' from msc_net_resource_avail b

850: AND avail.res_instance_id = list.number8
851: AND avail.serial_number = list.char3
852: AND nvl(avail.capacity_units,1) <> 0
853: AND list.query_id = g_item_list_id
854: -- AND not exists (select 'aggregate' from msc_net_resource_avail b
855: -- where b.shift_date = decode(v_agg_flag,1,null,avail.shift_date)
856: -- and b.resource_id = decode(v_agg_flag,1,null,avail.aggregate_resource_id)
857: -- and b.department_id = decode(v_agg_flag,1,null,avail.department_id)
858: -- and b.plan_id = avail.plan_id