APPS.MSC_GANTT_PKG dependencies on MSC_RESOURCE_INSTANCE_REQS

Line 1940: msc_resource_instance_reqs mrir

1936: select distinct mrir.sr_instance_id, mrir.organization_id, mrir.supply_id
1937: bulk collect into v_inst_id, v_org_id, v_trx_id
1938: from msc_gantt_query mgq,
1939: msc_gantt_dtl_query mgdq,
1940: msc_resource_instance_reqs mrir
1941: where mgq.query_id = p_from_query_id
1942: and mgq.row_index = p_from_index
1943: and mgq.query_id = mgdq.query_id
1944: and mgq.row_index = mgdq.row_index

Line 2456: msc_resource_instance_reqs mrir

2452: if ( p_node_type = RES_NODE ) then
2453: select count(*)
2454: into l_child_count
2455: from msc_resource_requirements mrr,
2456: msc_resource_instance_reqs mrir
2457: where mrr.plan_id = g_plan_id
2458: and mrr.sr_instance_id = p_inst_id
2459: and mrr.transaction_id = p_trx_id
2460: and mrr.plan_id = mrir.plan_id

Line 2524: from msc_resource_instance_reqs mrir

2520: elsif ( p_node_type = RES_INST_NODE ) then
2521:
2522: select mrir.resource_instance_hours
2523: into l_res_hours
2524: from msc_resource_instance_reqs mrir
2525: where mrir.plan_id = g_plan_id
2526: and mrir.sr_instance_id = p_inst_id
2527: and mrir.res_inst_transaction_id = p_trx_id
2528: for update of mrir.resource_instance_hours nowait;

Line 2530: update msc_resource_instance_reqs

2526: and mrir.sr_instance_id = p_inst_id
2527: and mrir.res_inst_transaction_id = p_trx_id
2528: for update of mrir.resource_instance_hours nowait;
2529:
2530: update msc_resource_instance_reqs
2531: set status =0,
2532: applied=2,
2533: resource_instance_hours = p_resource_hours
2534: where plan_id = g_plan_id

Line 2692: msc_resource_instance_reqs mrir,

2688: select distinct v_mfq_to_query_id, sysdate, -1, sysdate, -1, -1,
2689: mfp2.demand_id, mfp2.sr_instance_id
2690: from msc_full_pegging mfp2,
2691: msc_full_pegging mfp,
2692: msc_resource_instance_reqs mrir,
2693: msc_form_query mfq
2694: where mfq.query_id = v_mfq_from_query_id
2695: and mrir.plan_id = p_plan_id
2696: and mrir.sr_instance_id = mfq.number2

Line 2745: msc_resource_instance_reqs mrir

2741: select distinct v_mfq_to_query_id, sysdate, -1, sysdate, -1, -1,
2742: mfp2.demand_id, mfp2.sr_instance_id
2743: from msc_full_pegging mfp2,
2744: msc_full_pegging mfp,
2745: msc_resource_instance_reqs mrir
2746: where mrir.plan_id = p_plan_id
2747: and mrir.sr_instance_id = l_inst_id
2748: and mrir.organization_id = l_org_id
2749: and mrir.department_id = l_dept_id