APPS.MSC_ATP_REQ dependencies on MSC_SALES_ORDERS

Line 2103: MSC_SALES_ORDERS D,

2099: D.COMPLETED_QUANTITY)) SD_QTY
2100: FROM
2101: -- Bug 1756263, performance fix, use EXISTS subquery instead.
2102: --MSC_CALENDAR_DATES C,
2103: MSC_SALES_ORDERS D,
2104: MSC_ATP_RULES R,
2105: MSC_SYSTEM_ITEMS I,
2106: MSC_CALENDAR_DATES C
2107: WHERE I.SR_INVENTORY_ITEM_ID = p_item_id

Line 2647: MSC_SALES_ORDERS D,

2643: D.DEMAND_CLASS, --bug3263368
2644: trunc(DECODE(D.ORDER_DATE_TYPE_CODE,2,D.REQUEST_DATE, --4135752
2645: D.REQUEST_SHIP_DATE)) --bug3263368
2646: FROM
2647: MSC_SALES_ORDERS D,
2648: MSC_ATP_RULES R,
2649: MSC_SYSTEM_ITEMS I,
2650: MSC_CALENDAR_DATES C,
2651: MSC_TRADING_PARTNERS MTP,--bug3263368