DBA Data[Home] [Help]

APPS.MSC_ATP_PF dependencies on MSC_SALES_ORDERS

Line 2249: MSC_SALES_ORDERS D,

2245: D.COMPLETED_QUANTITY)) SD_QTY
2246: FROM
2247: -- Bug 1756263, performance fix, use EXISTS subquery instead.
2248: --MSC_CALENDAR_DATES C,
2249: MSC_SALES_ORDERS D,
2250: MSC_ATP_RULES R,
2251: MSC_SYSTEM_ITEMS I,
2252: MSC_SYSTEM_ITEMS I0,
2253: MSC_CALENDAR_DATES C

Line 2824: MSC_SALES_ORDERS D,

2820: D.DEMAND_CLASS, --bug3263368
2821: DECODE(D.ORDER_DATE_TYPE_CODE,2,D.REQUEST_DATE,
2822: D.REQUEST_SHIP_DATE) --bug3263368
2823: FROM
2824: MSC_SALES_ORDERS D,
2825: MSC_ATP_RULES R,
2826: MSC_SYSTEM_ITEMS I,
2827: MSC_SYSTEM_ITEMS I0,
2828: MSC_CALENDAR_DATES C,