[Home] [Help]
1878: (SELECT /*+ INDEX(D MSC_ATP_SUMMARY_SO_U1) */
1879: trunc(D.SD_DATE) SD_DATE, --4135752
1880: -1* D.SD_QTY SD_QTY
1881: FROM MSC_ATP_SUMMARY_SO D,
1882: MSC_ATP_RULES R,
1883: MSC_SYSTEM_ITEMS I
1884: WHERE I.SR_INVENTORY_ITEM_ID = p_item_id
1885: AND I.ORGANIZATION_ID = p_org_id
1886: AND I.SR_INSTANCE_ID = p_instance_id
1903: SELECT /*+ INDEX(S MSC_ATP_SUMMARY_SD_U1) */
1904: trunc(S.SD_DATE) SD_DATE, --4135752
1905: S.SD_QTY SD_QTY
1906: FROM MSC_ATP_SUMMARY_SD S,
1907: MSC_ATP_RULES R,
1908: MSC_SYSTEM_ITEMS I
1909: WHERE I.SR_INVENTORY_ITEM_ID = p_item_id
1910: AND I.ORGANIZATION_ID = p_org_id
1911: AND I.SR_INSTANCE_ID = p_instance_id
2043: SELECT C.PRIOR_DATE SD_DATE,
2044: -1* D.USING_REQUIREMENT_QUANTITY SD_QTY
2045: FROM MSC_CALENDAR_DATES C,
2046: MSC_DEMANDS D,
2047: MSC_ATP_RULES R,
2048: MSC_SYSTEM_ITEMS I
2049: WHERE I.SR_INVENTORY_ITEM_ID = p_item_id
2050: AND I.ORGANIZATION_ID = p_org_id
2051: AND I.SR_INSTANCE_ID = p_instance_id
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
2108: AND I.ORGANIZATION_ID = p_org_id
2154: 5, NVL(S.DAILY_RATE, NVL(S.FIRM_QUANTITY,S.NEW_ORDER_QUANTITY)),
2155: (NVL(S.FIRM_QUANTITY,S.NEW_ORDER_QUANTITY) - NVL(S.NON_NETTABLE_QTY, 0)) )SD_QTY
2156: FROM MSC_CALENDAR_DATES C,
2157: MSC_SUPPLIES S,
2158: MSC_ATP_RULES R,
2159: MSC_SYSTEM_ITEMS I,
2160: MSC_SUB_INVENTORIES MSI
2161: WHERE I.SR_INVENTORY_ITEM_ID = p_item_id
2162: AND I.ORGANIZATION_ID = p_org_id
2561: trunc(DECODE(D.ORDER_DATE_TYPE_CODE,2,D.REQUEST_DATE, --4135752
2562: D.REQUEST_SHIP_DATE)) --bug3263368
2563: FROM MSC_CALENDAR_DATES C,
2564: MSC_DEMANDS D,
2565: MSC_ATP_RULES R,
2566: MSC_SYSTEM_ITEMS I,
2567: MSC_TRADING_PARTNERS MTP,--bug3263368
2568: MSC_TRADING_PARTNER_SITES MTPS --bug3263368
2569: WHERE I.SR_INVENTORY_ITEM_ID = p_item_id
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
2652: MSC_TRADING_PARTNER_SITES MTPS --bug3263368
2758: l_null_char, --bug3814584
2759: l_null_date --bug3814584
2760: FROM MSC_CALENDAR_DATES C,
2761: MSC_SUPPLIES S,
2762: MSC_ATP_RULES R,
2763: MSC_SYSTEM_ITEMS I,
2764: MSC_SUB_INVENTORIES MSI
2765: WHERE I.SR_INVENTORY_ITEM_ID = p_item_id
2766: AND I.ORGANIZATION_ID = p_org_id