[Home] [Help]
300: GREATEST(NVL(D.RESERVATION_QUANTITY,0),
301: D.COMPLETED_QUANTITY)
302: AND (D.SUBINVENTORY IS NULL OR D.SUBINVENTORY IN
303: (SELECT S.SUB_INVENTORY_CODE
304: FROM MSC_SUB_INVENTORIES S
305: WHERE S.ORGANIZATION_ID=D.ORGANIZATION_ID
306: AND S.PLAN_ID = I.PLAN_ID
307: AND S.SR_INSTANCE_ID = D.SR_INSTANCE_ID
308: AND S.INVENTORY_ATP_CODE =DECODE(R.DEFAULT_ATP_SOURCES,
434: MSC_SYSTEM_ITEMS I,
435: MSC_SYSTEM_ITEMS I2,
436: MSC_ATP_RULES R,
437: MSC_SUPPLIES S,
438: MSC_SUB_INVENTORIES MSI,
439: MSC_CALENDAR_DATES C,
440: MSC_CALENDAR_DATES C2,
441: MSC_TRADING_PARTNERS TP
442: WHERE I.ATP_FLAG = 'Y'
2052: -- the demand for which the sales_order has been pegged
2053: (D.RESERVATION_TYPE = 2 AND D.DEMAND_SOURCE_LINE IS NOT NULL))
2054: AND (D.SUBINVENTORY IS NULL OR D.SUBINVENTORY IN
2055: (SELECT S.SUB_INVENTORY_CODE
2056: FROM MSC_SUB_INVENTORIES S
2057: WHERE S.ORGANIZATION_ID=D.ORGANIZATION_ID
2058: AND S.PLAN_ID = I.PLAN_ID
2059: AND S.SR_INSTANCE_ID = D.SR_INSTANCE_ID
2060: AND S.INVENTORY_ATP_CODE =DECODE(R.DEFAULT_ATP_SOURCES,
2121: AND D.PRIMARY_UOM_QUANTITY > GREATEST(NVL(D.RESERVATION_QUANTITY,0),
2122: NVL(D.COMPLETED_QUANTITY,0))
2123: AND (D.SUBINVENTORY IS NULL OR D.SUBINVENTORY IN
2124: (SELECT S.SUB_INVENTORY_CODE
2125: FROM MSC_SUB_INVENTORIES S
2126: WHERE S.ORGANIZATION_ID=D.ORGANIZATION_ID
2127: AND S.PLAN_ID = I.PLAN_ID
2128: AND S.SR_INSTANCE_ID = D.SR_INSTANCE_ID
2129: AND S.INVENTORY_ATP_CODE =DECODE(R.DEFAULT_ATP_SOURCES,
2215: --AND D.DEMAND_SOURCE_LINE is NULL -- new inventory reservations.
2216: AND D.RESERVATION_TYPE <> 1 -- Not a Sales Order item.
2217: AND (D.SUBINVENTORY IS NULL OR D.SUBINVENTORY IN
2218: (SELECT S.SUB_INVENTORY_CODE
2219: FROM MSC_SUB_INVENTORIES S
2220: WHERE S.ORGANIZATION_ID=D.ORGANIZATION_ID
2221: AND S.PLAN_ID = I.PLAN_ID
2222: AND S.SR_INSTANCE_ID = D.SR_INSTANCE_ID
2223: AND S.INVENTORY_ATP_CODE =DECODE(R.DEFAULT_ATP_SOURCES,
2293: OR (D.RESERVATION_TYPE = 1 AND NVL(D.COMPLETED_QUANTITY,0) <> 0))
2294:
2295: AND (D.SUBINVENTORY IS NULL OR D.SUBINVENTORY IN
2296: (SELECT S.SUB_INVENTORY_CODE
2297: FROM MSC_SUB_INVENTORIES S
2298: WHERE S.ORGANIZATION_ID=D.ORGANIZATION_ID
2299: AND S.PLAN_ID = I.PLAN_ID
2300: AND S.SR_INSTANCE_ID = D.SR_INSTANCE_ID
2301: AND S.INVENTORY_ATP_CODE =DECODE(R.DEFAULT_ATP_SOURCES,
3004: FROM MSC_SYSTEM_ITEMS I,
3005: MSC_SYSTEM_ITEMS I2,
3006: MSC_SUPPLIES S,
3007: MSC_ATP_RULES R,
3008: MSC_SUB_INVENTORIES MSI,
3009: MSC_CALENDAR_DATES C
3010:
3011: /* FROM MSC_CALENDAR_DATES C,
3012: MSC_SUPPLIES S,
3013: MSC_ATP_RULES R,
3014: MSC_SYSTEM_ITEMS I,
3015: --- bug 2162571 add to another table to get info about product family
3016: MSC_SYSTEM_ITEMS I2,
3017: MSC_SUB_INVENTORIES MSI*/ -- commented for 5098576/5199686
3018: WHERE I.ATP_FLAG = 'Y' ---I.SR_INVENTORY_ITEM_ID = p_inventory_item_id
3019: AND I.ORGANIZATION_ID = l_organization_id
3020: AND I.SR_INSTANCE_ID = p_instance_id
3021: AND I.PLAN_ID = -1
3113: MSC_SUPPLIES S,
3114: MSC_ATP_RULES R,
3115: MSC_SYSTEM_ITEMS I,
3116: MSC_SYSTEM_ITEMS I2,
3117: MSC_SUB_INVENTORIES MSI*/
3118: -- Commented 5098576./5199686
3119: -- changed order of tables for 5098576/5199686
3120: FROM MSC_SYSTEM_ITEMS I,
3121: MSC_SYSTEM_ITEMS I2,
3120: FROM MSC_SYSTEM_ITEMS I,
3121: MSC_SYSTEM_ITEMS I2,
3122: MSC_SUPPLIES S,
3123: MSC_ATP_RULES R,
3124: MSC_SUB_INVENTORIES MSI,
3125: MSC_CALENDAR_DATES C
3126:
3127: WHERE I.ATP_FLAG = 'Y'
3128: AND I.ORGANIZATION_ID = l_organization_id