DBA Data[Home] [Help]

APPS.MSC_GET_GANTT_DATA dependencies on MSC_NET_RESOURCE_AVAIL

Line 495: from msc_net_resource_avail

491: and plan_id = -1;
492:
493: CURSOR finite_avail IS
494: select 1
495: from msc_net_resource_avail
496: where organization_id =v_org_id
497: and sr_instance_id = v_instance_id
498: and department_id = v_dept_id
499: and resource_id = v_res_id

Line 805: from msc_net_resource_avail mrr

801: shift_date+to_time/86400,
802: shift_date+1+to_time/86400),
803: capacity_units
804: bulk collect into v_avail_start, v_avail_end, v_avail_qty
805: from msc_net_resource_avail mrr
806: where organization_id =v_org_id
807: and sr_instance_id = v_instance_id
808: and department_id = v_dept_id
809: and resource_id = v_res_id