[Home] [Help]
1657: 0 old_quantity
1658: FROM mrp_form_query list,
1659: bom_calendar_dates dates,
1660: mtl_parameters param,
1661: mrp_recommendations recom,
1662: mrp_gross_requirements reqs,
1663: mrp_system_items items,
1664: mrp_plan_organizations_v mpov /*1402080*/
1665: WHERE (arg_res_level = 1
1958: (nvl(rec.implemented_quantity, 0)
1959: + nvl(rec.quantity_in_process, 0)))) new_quantity,
1960: 0 old_quantity
1961: FROM mrp_form_query list,
1962: mrp_recommendations rec
1963: WHERE (arg_res_level = 1
1964: OR (arg_res_level = 2
1965: AND rec.project_id is NULL)
1966: OR (DECODE(arg_res_level,
2000: rec.old_schedule_date old_date,
2001: SUM(-1 * rec.new_order_quantity),
2002: 0 old_quantity
2003: FROM mrp_form_query list,
2004: mrp_recommendations rec
2005: WHERE (arg_res_level = 1
2006: OR (arg_res_level = 2
2007: AND rec.project_id is NULL)
2008: OR (DECODE(arg_res_level,
2040: rec.old_schedule_date old_date,
2041: SUM(rec.new_order_quantity*NVL(items.shrinkage_rate, 0)) new_quantity,
2042: 0 old_quantity
2043: FROM mrp_form_query list,
2044: mrp_recommendations rec,
2045: mrp_system_items items
2046: WHERE (arg_res_level = 1
2047: OR (arg_res_level = 2
2048: AND rec.project_id is NULL)
2630:
2631: -- --------------------------------------------
2632: -- This cursor selects the snapshot activity in
2633: -- MRP_GROSS_REQUIREMENTS and
2634: -- MRP_RECOMMENDATIONS for the items in the
2635: -- item list.
2636: -- --------------------------------------------
2637: CURSOR mrp_snapshot_activity IS
2638: SELECT rec.inventory_item_id item_id,
2685: , 0)) new_quantity,
2686: SUM(NVL(rec.old_order_quantity,0)) old_quantity
2687: FROM mrp_form_query list,
2688: mtl_parameters param,
2689: mrp_recommendations rec,
2690: bom_calendar_dates dates
2691: WHERE (arg_res_level = 1
2692: OR (arg_res_level = 2
2693: AND rec.project_id is NULL)