2093: -- demands and supplies are stored on PF level
2094: SELECT SD_DATE, sum(SD_QTY)
2095: BULK COLLECT INTO x_atp_dates, x_atp_qtys
2096: FROM
2097: (SELECT /*+ INDEX(D MSC_ATP_SUMMARY_SO_U1) */
2098: D.SD_DATE SD_DATE,
2099: -1* D.SD_QTY SD_QTY
2100: FROM MSC_ATP_SUMMARY_SO D,
2101: MSC_ATP_RULES R,
2096: FROM
2097: (SELECT /*+ INDEX(D MSC_ATP_SUMMARY_SO_U1) */
2098: D.SD_DATE SD_DATE,
2099: -1* D.SD_QTY SD_QTY
2100: FROM MSC_ATP_SUMMARY_SO D,
2101: MSC_ATP_RULES R,
2102: MSC_SYSTEM_ITEMS I,
2103: MSC_SYSTEM_ITEMS I0
2104: WHERE I0.SR_INVENTORY_ITEM_ID = p_item_id