4245: END;
4246:
4247: ELSIF p_mode = 4 THEN
4248: BEGIN
4249: select /*+ INDEX(msc_atp_summary_sup MSC_ATP_SUMMARY_SUP_U1) */ sd_qty
4250: into temp_sd_qty
4251: from msc_atp_summary_sup
4252: where plan_id = p_plan_id
4253: and sr_instance_id = p_instance_id
4247: ELSIF p_mode = 4 THEN
4248: BEGIN
4249: select /*+ INDEX(msc_atp_summary_sup MSC_ATP_SUMMARY_SUP_U1) */ sd_qty
4250: into temp_sd_qty
4251: from msc_atp_summary_sup
4252: where plan_id = p_plan_id
4253: and sr_instance_id = p_instance_id
4254: and inventory_item_id = p_inventory_item_id
4255: and supplier_id = p_supplier_id