APPS.MSC_ATP_PROC dependencies on MSC_ATP_SUMMARY_SD

Line 4214: select /*+ INDEX(msc_atp_summary_sd MSC_ATP_SUMMARY_SD_U1) */ sd_qty

4210: temp_sd_qty := -9999;
4211: END;
4212: ELSIF p_mode = 2 THEN
4213: BEGIN
4214: select /*+ INDEX(msc_atp_summary_sd MSC_ATP_SUMMARY_SD_U1) */ sd_qty
4215: into temp_sd_qty
4216: from MSC_ATP_SUMMARY_SD
4217: where sr_instance_id = p_instance_id
4218: and inventory_item_id = p_inventory_item_id

Line 4216: from MSC_ATP_SUMMARY_SD

4212: ELSIF p_mode = 2 THEN
4213: BEGIN
4214: select /*+ INDEX(msc_atp_summary_sd MSC_ATP_SUMMARY_SD_U1) */ sd_qty
4215: into temp_sd_qty
4216: from MSC_ATP_SUMMARY_SD
4217: where sr_instance_id = p_instance_id
4218: and inventory_item_id = p_inventory_item_id
4219: and organization_id = p_organization_id
4220: and sd_date = trunc(p_sd_date)