[Home] [Help]
429: sysdate,
430: fnd_global.user_id,
431: fnd_global.conc_login_id
432: From CSP_PLANNING_PARAMETERS cpp,
433: MTL_ITEM_SUB_INVENTORIES mis,
434: CST_ITEM_COSTS cic,
435: MTL_PARAMETERS mp
436: where cpp.node_type = 'SUBINVENTORY'
437: and mis.organization_id = cpp.organization_id
567: csp_usage_headers cuh,
568: cst_item_costs cic,
569: mtl_parameters mp,
570: mtl_system_items_b msib,
571: mtl_item_sub_inventories misi,
572: mtl_secondary_inventories msi,
573: mtl_interorg_ship_methods mism1,
574: mtl_interorg_ship_methods mism2,
575: mtl_interorg_ship_methods mism3,
2188: from csp_region_items_v cri,
2189: mtl_related_items mri,
2190: mtl_parameters mp,
2191: mtl_system_items_b msib,
2192: mtl_item_sub_inventories misi,
2193: mtl_secondary_inventories msi
2194: where cri.level_id like l_level_id || '%'
2195: and mp.organization_id = cri.organization_id
2196: and mri.organization_id = mp.master_organization_id
2238: fnd_global.user_id,
2239: sysdate
2240: from mtl_parameters mp,
2241: mtl_system_items_b msib,
2242: mtl_item_sub_inventories misi,
2243: mtl_secondary_inventories msi,
2244: csp_supply_chain csc
2245: where mp.organization_id = csc.source_organization_id
2246: and misi.organization_id (+) = csc.source_organization_id
2416: fnd_global.user_id,
2417: sysdate
2418: from mtl_parameters mp,
2419: mtl_system_items_b msib,
2420: mtl_item_sub_inventories misi,
2421: mtl_secondary_inventories msi,
2422: mtl_material_transactions mmt,
2423: mtl_interorg_ship_methods mism
2424: where mp.organization_id = mmt.organization_id
2482: fnd_global.user_id,
2483: sysdate
2484: from mtl_parameters mp,
2485: mtl_system_items_b msib,
2486: mtl_item_sub_inventories misi,
2487: mtl_secondary_inventories msi,
2488: csp_supply_chain csc,
2489: mtl_interorg_ship_methods mism
2490: where mp.organization_id = csc.source_organization_id
2796: cuh.ORGANIZATION_ID,
2797: cuh.SECONDARY_INVENTORY
2798: From csp_usage_headers cuh,
2799: csp_planning_parameters cpp,
2800: mtl_item_sub_inventories misi,
2801: csp_business_rules_b cbrb
2802: Where header_data_type = 1
2803: and process_status = 'O'
2804: and cuh.planning_parameters_id = cpp.planning_parameters_id
2873:
2874: -- Removed for database version compatibility
2875: -- issues. Replaced with UPDATE/INSERT
2876: /*
2877: MERGE INTO MTL_ITEM_SUB_INVENTORIES item_subinv USING
2878: (Select cuh.Inventory_Item_Id,
2879: cuh.Organization_Id,
2880: cuh.secondary_inventory,
2881: cuh.recommended_min_quantity,
2881: cuh.recommended_min_quantity,
2882: cuh.recommended_max_quantity
2883: From csp_usage_headers cuh,
2884: csp_planning_parameters cpp,
2885: mtl_item_sub_inventories misi,
2886: CSP.csp_business_rules_b cbrb
2887: Where cuh.planning_parameters_id = cpp.planning_parameters_id
2888: and misi.organization_id(+) = cuh.organization_id
2889: and misi.inventory_item_id(+) = cuh.inventory_item_id
2935: sq.RECOMMENDED_MAX_QUANTITY,2);
2936: COMMIT;
2937: */
2938: FOR usg_hdr_rec in c_usg_hdr_subinv LOOP
2939: UPDATE MTL_ITEM_SUB_INVENTORIES item_subinv
2940: SET MIN_MINMAX_QUANTITY = usg_hdr_rec.RECOMMENDED_MIN_QUANTITY,
2941: MAX_MINMAX_QUANTITY = usg_hdr_rec.RECOMMENDED_MAX_QUANTITY,
2942: INVENTORY_PLANNING_CODE = 2
2943: WHERE item_subinv.INVENTORY_ITEM_ID = usg_hdr_rec.INVENTORY_ITEM_ID
2943: WHERE item_subinv.INVENTORY_ITEM_ID = usg_hdr_rec.INVENTORY_ITEM_ID
2944: and item_subinv.ORGANIZATION_ID = usg_hdr_rec.ORGANIZATION_ID
2945: and item_subinv.SECONDARY_INVENTORY = usg_hdr_rec.SECONDARY_INVENTORY;
2946: IF SQL%NOTFOUND THEN
2947: INSERT INTO MTL_ITEM_SUB_INVENTORIES
2948: (INVENTORY_ITEM_ID,
2949: ORGANIZATION_ID,
2950: SECONDARY_INVENTORY,
2951: LAST_UPDATE_DATE,