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 659: FROM msc_net_resource_avail avail,

655:
656: --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))),
657: to_number(-1),
658: to_char('-1')
659: FROM msc_net_resource_avail avail,
660: msc_plans mp,
661: msc_form_query list
662: WHERE trunc(avail.shift_date) <= trunc(g_cutoff_date)
663: AND avail.shift_date >= g_dates(1)+1

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

670: AND avail.capacity_units >= 0
671: AND list.query_id = g_item_list_id
672: AND mp.plan_id=avail.plan_id
673: /*
674: AND not exists (select 'aggregate' from msc_net_resource_avail b
675: where b.shift_date = decode(v_agg_flag,1,null,avail.shift_date)
676: and b.resource_id = decode(v_agg_flag,1,null,avail.aggregate_resource_id)
677: and b.department_id = decode(v_agg_flag,1,null,avail.department_id)
678: and b.plan_id = avail.plan_id

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

1025: AND avail.serial_number = list.char3
1026: AND nvl(avail.capacity_units,1) <> 0
1027: AND list.query_id = g_item_list_id
1028: AND mp.plan_id= avail.plan_id
1029: -- AND not exists (select 'aggregate' from msc_net_resource_avail b
1030: -- where b.shift_date = decode(v_agg_flag,1,null,avail.shift_date)
1031: -- and b.resource_id = decode(v_agg_flag,1,null,avail.aggregate_resource_id)
1032: -- and b.department_id = decode(v_agg_flag,1,null,avail.department_id)
1033: -- and b.plan_id = avail.plan_id