[Home] [Help]
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
286: WHERE I.ATP_FLAG = 'Y'
948: /* Find out if this is CMRO scenario */
949: FOR j IN l_organization_id.first.. l_organization_id.last LOOP
950: select count(*)
951: into l_is_cmro
952: from msc_sales_orders so
953: where demand_source_type = 100
954: and organization_id=l_organization_id(j)
955: and sr_instance_id = l_sr_instance_id(j);
956:
963: msc_util.msc_log ('This is a CMRO scenario...');
964: FORALL j IN l_organization_id.first.. l_organization_id.last
965: update msc_demands dem
966: set demand_source_type = (select demand_source_type
967: from msc_sales_orders so
968: where so.sales_order_number = dem.order_number
969: and so.organization_id = dem.organization_id
970: and so.sr_instance_id = dem.sr_instance_id
971: and so.inventory_item_id = dem.inventory_item_id
2029: SUM ( (D.PRIMARY_UOM_QUANTITY -
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
2101: NVL(D.DEMAND_CLASS,'@@@'), '@@@') demand_class ,
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
2164: trunc(d.requirement_date) SD_DATE,
2165: sum(nvl(d.old_primary_uom_quantity, 0) - d.primary_uom_quantity) SD_QTY
2166: -- QUESTION ? Does the above SUM actually result in a DELTA??
2167: FROM
2168: msc_sales_orders d
2169: WHERE
2170: d.reservation_type =2
2171: and d.refresh_number > l_refresh_number
2172: and d.organization_id = l_organization_id
2194: --GREATEST(NVL(D.RESERVATION_QUANTITY,0),
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
2266: NVL(D.old_COMPLETED_QUANTITY,0))))) sd_qty
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