DBA Data[Home] [Help]

APPS.MSC_CRP_HORIZONTAL_PLAN dependencies on MSC_NET_RES_INST_AVAIL

Line 1014: FROM msc_net_res_inst_avail avail, msc_plans mp,

1010:
1011: --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))),
1012: avail.res_instance_id,
1013: avail.serial_number
1014: FROM msc_net_res_inst_avail avail, msc_plans mp,
1015: msc_form_query list
1016: WHERE trunc(avail.shift_date) <= trunc(g_cutoff_date)
1017: AND avail.shift_date >= g_dates(1)+1
1018: AND NVL(avail.parent_id,0) <> -1