APPS.MSC_ATP_REQ dependencies on MSC_ATP_SUMMARY_RES

Line 1478: select /*+ INDEX(r MSC_ATP_SUMMARY_RES_U1) */

1474: SUM(SD_QTY)
1475: BULK COLLECT INTO x_atp_dates, x_atp_qtys
1476: FROM
1477: (
1478: select /*+ INDEX(r MSC_ATP_SUMMARY_RES_U1) */
1479: trunc(r.sd_date) SD_DATE, --4135752
1480: r.sd_qty
1481: from msc_atp_summary_res r
1482: where r.plan_id = p_plan_id and

Line 1481: from msc_atp_summary_res r

1477: (
1478: select /*+ INDEX(r MSC_ATP_SUMMARY_RES_U1) */
1479: trunc(r.sd_date) SD_DATE, --4135752
1480: r.sd_qty
1481: from msc_atp_summary_res r
1482: where r.plan_id = p_plan_id and
1483: r.sr_instance_id = p_instance_id and
1484: r.organization_id = p_org_id and
1485: r.department_id = p_dept_id and