DBA Data[Home] [Help]

APPS.MSC_CRP_HORIZONTAL_PLAN dependencies on MSC_NET_RES_INST_AVAIL

Line 840: FROM msc_net_res_inst_avail avail,

836: to_date(NULL),
837: sum(nvl(avail.capacity_units,1) * 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))),
838: avail.res_instance_id,
839: avail.serial_number
840: FROM msc_net_res_inst_avail avail,
841: msc_form_query list
842: WHERE trunc(avail.shift_date) <= trunc(g_cutoff_date)
843: AND avail.shift_date >= g_dates(1)+1
844: AND NVL(avail.parent_id,0) <> -1