APPS.MSC_ATP_REQ dependencies on MSC_ATP_SUMMARY_SO

Line 1878: (SELECT /*+ INDEX(D MSC_ATP_SUMMARY_SO_U1) */

1874:
1875: SELECT SD_DATE, sum(SD_QTY)
1876: BULK COLLECT INTO x_atp_dates, x_atp_qtys
1877: FROM
1878: (SELECT /*+ INDEX(D MSC_ATP_SUMMARY_SO_U1) */
1879: trunc(D.SD_DATE) SD_DATE, --4135752
1880: -1* D.SD_QTY SD_QTY
1881: FROM MSC_ATP_SUMMARY_SO D,
1882: MSC_ATP_RULES R,

Line 1881: FROM MSC_ATP_SUMMARY_SO D,

1877: FROM
1878: (SELECT /*+ INDEX(D MSC_ATP_SUMMARY_SO_U1) */
1879: trunc(D.SD_DATE) SD_DATE, --4135752
1880: -1* D.SD_QTY SD_QTY
1881: FROM MSC_ATP_SUMMARY_SO D,
1882: MSC_ATP_RULES R,
1883: MSC_SYSTEM_ITEMS I
1884: WHERE I.SR_INVENTORY_ITEM_ID = p_item_id
1885: AND I.ORGANIZATION_ID = p_org_id