[Home] [Help]
277: GREATEST(NVL(D.RESERVATION_QUANTITY,0),
278: D.COMPLETED_QUANTITY)) sd_qty
279: FROM
280: MSC_SYSTEM_ITEMS I,
281: MSC_ATP_RULES R,
282: MSC_SALES_ORDERS D,
283: MSC_CALENDAR_DATES C,
284: MSC_CALENDAR_DATES C2,
285: MSC_TRADING_PARTNERS TP
370: -1* D.USING_REQUIREMENT_QUANTITY SD_QTY
371: FROM
372: MSC_SYSTEM_ITEMS I,
373: MSC_SYSTEM_ITEMS I2,
374: MSC_ATP_RULES R,
375: MSC_DEMANDS D,
376: MSC_CALENDAR_DATES C,
377: MSC_CALENDAR_DATES C2,
378: MSC_TRADING_PARTNERS TP
432: NVL(S.FIRM_QUANTITY,S.NEW_ORDER_QUANTITY) ) SD_QTY
433: FROM
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,
2030: GREATEST(NVL(D.RESERVATION_QUANTITY,0),
2031: D.COMPLETED_QUANTITY)) ) sd_qty
2032: FROM
2033: MSC_SALES_ORDERS D,
2034: MSC_ATP_RULES R,
2035: MSC_SYSTEM_ITEMS I
2036: WHERE D.SR_INSTANCE_ID = l_instance_id
2037: AND I.REFRESH_NUMBER > l_refresh_number -- get all new flag items
2038: AND I.ORGANIZATION_ID = l_organization_id
2102: trunc(D.REQUIREMENT_DATE) SD_DATE,
2103: sum(d.old_RESERVATION_QUANTITY) sd_qty
2104: FROM
2105: MSC_SALES_ORDERS D,
2106: MSC_ATP_RULES R,
2107: MSC_SYSTEM_ITEMS I
2108: WHERE D.SR_INSTANCE_ID = l_instance_id
2109: AND D.REFRESH_NUMBER > l_refresh_number
2110: AND I.ORGANIZATION_ID = l_organization_id
2195: --NVL(D.COMPLETED_QUANTITY,0))) ) sd_qty
2196: -- QUESTION ? Does the above SUM actually result in a DELTA??
2197: FROM
2198: MSC_SALES_ORDERS D,
2199: MSC_ATP_RULES R,
2200: MSC_SYSTEM_ITEMS I
2201: WHERE D.SR_INSTANCE_ID = l_instance_id
2202: AND D.REFRESH_NUMBER > l_refresh_number
2203: AND I.ORGANIZATION_ID = l_organization_id
2267: -- QUESTION ? Does the above SUM actually result in a DELTA??
2268: -- ANSWER : We are subtratcting the sum of the old quantities.
2269: FROM
2270: MSC_SALES_ORDERS D,
2271: MSC_ATP_RULES R,
2272: MSC_SYSTEM_ITEMS I
2273: WHERE D.SR_INSTANCE_ID = l_instance_id
2274: AND D.REFRESH_NUMBER > l_refresh_number
2275: AND I.ORGANIZATION_ID = l_organization_id
2887: -1* D.USING_REQUIREMENT_QUANTITY SD_QTY
2888: --2 SD_TYPE
2889: FROM MSC_CALENDAR_DATES C,
2890: MSC_DEMANDS D,
2891: MSC_ATP_RULES R,
2892: MSC_SYSTEM_ITEMS I,
2893: MSC_SYSTEM_ITEMS I2
2894: WHERE I.ATP_FLAG = 'Y' --- I.SR_INVENTORY_ITEM_ID = p_inventory_item_id
2895: AND I.ORGANIZATION_ID = l_organization_id
2942: NVL(D.OLD_USING_REQUIREMENT_QUANTITY,0) SD_QTY
2943: --2 SD_TYPE
2944: FROM MSC_CALENDAR_DATES C,
2945: MSC_DEMANDS D,
2946: MSC_ATP_RULES R,
2947: MSC_SYSTEM_ITEMS I,
2948: MSC_SYSTEM_ITEMS I2
2949: WHERE I.ATP_FLAG = 'Y' --- I.SR_INVENTORY_ITEM_ID = p_inventory_item_id
2950: AND I.ORGANIZATION_ID = l_organization_id
3003: -- Changed the order of the tables for 5098576/5199686
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,
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
3110: NVL( NVL(S.OLD_FIRM_QUANTITY,S.OLD_NEW_ORDER_QUANTITY),0) ) SD_QTY
3111:
3112: /*FROM MSC_CALENDAR_DATES C,
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,
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'