DBA Data[Home] [Help]

APPS.MSC_ATP_PF dependencies on MSC_SALES_ORDERS

Line 2242: MSC_SALES_ORDERS D,

2238: D.COMPLETED_QUANTITY)) SD_QTY
2239: FROM
2240: -- Bug 1756263, performance fix, use EXISTS subquery instead.
2241: --MSC_CALENDAR_DATES C,
2242: MSC_SALES_ORDERS D,
2243: MSC_ATP_RULES R,
2244: MSC_SYSTEM_ITEMS I,
2245: MSC_SYSTEM_ITEMS I0,
2246: MSC_CALENDAR_DATES C

Line 2812: MSC_SALES_ORDERS D,

2808: D.DEMAND_CLASS, --bug3263368
2809: DECODE(D.ORDER_DATE_TYPE_CODE,2,D.REQUEST_DATE,
2810: D.REQUEST_SHIP_DATE) --bug3263368
2811: FROM
2812: MSC_SALES_ORDERS D,
2813: MSC_ATP_RULES R,
2814: MSC_SYSTEM_ITEMS I,
2815: MSC_SYSTEM_ITEMS I0,
2816: MSC_CALENDAR_DATES C,