APPS.MSC_ATP_PROC dependencies on MSC_ATP_SUMMARY_RES

Line 4222: select /*+ INDEX(msc_atp_summary_res MSC_ATP_SUMMARY_RES_U1) */ sd_qty

4218: END;
4219:
4220: ELSIF p_mode = 3 THEN
4221: BEGIN
4222: select /*+ INDEX(msc_atp_summary_res MSC_ATP_SUMMARY_RES_U1) */ sd_qty
4223: into temp_sd_qty
4224: from msc_atp_summary_res
4225: where plan_id = p_plan_id
4226: and sr_instance_id = p_instance_id

Line 4224: from msc_atp_summary_res

4220: ELSIF p_mode = 3 THEN
4221: BEGIN
4222: select /*+ INDEX(msc_atp_summary_res MSC_ATP_SUMMARY_RES_U1) */ sd_qty
4223: into temp_sd_qty
4224: from msc_atp_summary_res
4225: where plan_id = p_plan_id
4226: and sr_instance_id = p_instance_id
4227: and organization_id = p_organization_id
4228: and resource_id = p_resource_id