DBA Data[Home] [Help]

APPS.MSC_GANTT_UTILS dependencies on MSC_NET_RESOURCE_AVAIL

Line 2328: from msc_net_resource_avail mrr,

2324: mrr.capacity_units,
2325: to_number(null) schdule_flag
2326: bulk collect into v_row_index, v_avail_start, v_avail_end,
2327: v_resource_hours, v_resource_units, v_schdule_flag
2328: from msc_net_resource_avail mrr,
2329: msc_gantt_query mgq
2330: where mgq.query_id = p_query_id
2331: and mgq.row_flag = SYS_YES
2332: and mgq.is_fetched = SYS_NO

Line 4474: from msc_net_resource_avail mnra,

4470: and mdr.plan_id = -1;
4471:
4472: cursor finite_avail (l_query_id number, l_row_index number) is
4473: select 1
4474: from msc_net_resource_avail mnra,
4475: msc_gantt_query mgq
4476: where mgq.query_id = l_query_id
4477: and mgq.row_index = l_row_index
4478: and mgq.organization_id = mnra.organization_id