APPS.MSC_ATP_PROC dependencies on MSC_ATP_SUMMARY_SO

Line 4198: select /*+ INDEX(msc_atp_summary_so MSC_ATP_SUMMARY_SO_U1) */ sd_qty

4194: END IF;
4195:
4196: IF p_mode = 1 THEN
4197: BEGIN
4198: select /*+ INDEX(msc_atp_summary_so MSC_ATP_SUMMARY_SO_U1) */ sd_qty
4199: into temp_sd_qty
4200: from MSC_ATP_SUMMARY_SO
4201: where inventory_item_id = p_inventory_item_id and
4202: organization_id = p_organization_id and

Line 4200: from MSC_ATP_SUMMARY_SO

4196: IF p_mode = 1 THEN
4197: BEGIN
4198: select /*+ INDEX(msc_atp_summary_so MSC_ATP_SUMMARY_SO_U1) */ sd_qty
4199: into temp_sd_qty
4200: from MSC_ATP_SUMMARY_SO
4201: where inventory_item_id = p_inventory_item_id and
4202: organization_id = p_organization_id and
4203: sr_instance_id = p_instance_id and
4204: sd_date = trunc(p_sd_date) and