APPS.MSC_ATP_PF dependencies on MSC_ATP_SUMMARY_SO

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

2086: -- demands and supplies are stored on PF level
2087: SELECT SD_DATE, sum(SD_QTY)
2088: BULK COLLECT INTO x_atp_dates, x_atp_qtys
2089: FROM
2090: (SELECT /*+ INDEX(D MSC_ATP_SUMMARY_SO_U1) */
2091: D.SD_DATE SD_DATE,
2092: -1* D.SD_QTY SD_QTY
2093: FROM MSC_ATP_SUMMARY_SO D,
2094: MSC_ATP_RULES R,

Line 2093: FROM MSC_ATP_SUMMARY_SO D,

2089: FROM
2090: (SELECT /*+ INDEX(D MSC_ATP_SUMMARY_SO_U1) */
2091: D.SD_DATE SD_DATE,
2092: -1* D.SD_QTY SD_QTY
2093: FROM MSC_ATP_SUMMARY_SO D,
2094: MSC_ATP_RULES R,
2095: MSC_SYSTEM_ITEMS I,
2096: MSC_SYSTEM_ITEMS I0
2097: WHERE I0.SR_INVENTORY_ITEM_ID = p_item_id