4236: END;
4237:
4238: ELSIF p_mode = 4 THEN
4239: BEGIN
4240: select /*+ INDEX(msc_atp_summary_sup MSC_ATP_SUMMARY_SUP_U1) */ sd_qty
4241: into temp_sd_qty
4242: from msc_atp_summary_sup
4243: where plan_id = p_plan_id
4244: and sr_instance_id = p_instance_id
4238: ELSIF p_mode = 4 THEN
4239: BEGIN
4240: select /*+ INDEX(msc_atp_summary_sup MSC_ATP_SUMMARY_SUP_U1) */ sd_qty
4241: into temp_sd_qty
4242: from msc_atp_summary_sup
4243: where plan_id = p_plan_id
4244: and sr_instance_id = p_instance_id
4245: and inventory_item_id = p_inventory_item_id
4246: and supplier_id = p_supplier_id