[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,
2168: from csp_region_items_v cri,
2169: mtl_related_items mri,
2170: mtl_parameters mp,
2171: mtl_system_items_b msib,
2172: mtl_item_sub_inventories misi,
2173: mtl_secondary_inventories msi
2174: where cri.level_id like l_level_id || '%'
2175: and mp.organization_id = cri.organization_id
2176: and mri.organization_id = mp.master_organization_id
2218: fnd_global.user_id,
2219: sysdate
2220: from mtl_parameters mp,
2221: mtl_system_items_b msib,
2222: mtl_item_sub_inventories misi,
2223: mtl_secondary_inventories msi,
2224: csp_supply_chain csc
2225: where mp.organization_id = csc.source_organization_id
2226: and misi.organization_id (+) = csc.source_organization_id
2396: fnd_global.user_id,
2397: sysdate
2398: from mtl_parameters mp,
2399: mtl_system_items_b msib,
2400: mtl_item_sub_inventories misi,
2401: mtl_secondary_inventories msi,
2402: mtl_material_transactions mmt,
2403: mtl_interorg_ship_methods mism
2404: where mp.organization_id = mmt.organization_id
2462: fnd_global.user_id,
2463: sysdate
2464: from mtl_parameters mp,
2465: mtl_system_items_b msib,
2466: mtl_item_sub_inventories misi,
2467: mtl_secondary_inventories msi,
2468: csp_supply_chain csc,
2469: mtl_interorg_ship_methods mism
2470: where mp.organization_id = csc.source_organization_id
2776: cuh.ORGANIZATION_ID,
2777: cuh.SECONDARY_INVENTORY
2778: From csp_usage_headers cuh,
2779: csp_planning_parameters cpp,
2780: mtl_item_sub_inventories misi,
2781: csp_business_rules_b cbrb
2782: Where header_data_type = 1
2783: and process_status = 'O'
2784: and cuh.planning_parameters_id = cpp.planning_parameters_id
2853:
2854: -- Removed for database version compatibility
2855: -- issues. Replaced with UPDATE/INSERT
2856: /*
2857: MERGE INTO MTL_ITEM_SUB_INVENTORIES item_subinv USING
2858: (Select cuh.Inventory_Item_Id,
2859: cuh.Organization_Id,
2860: cuh.secondary_inventory,
2861: cuh.recommended_min_quantity,
2861: cuh.recommended_min_quantity,
2862: cuh.recommended_max_quantity
2863: From csp_usage_headers cuh,
2864: csp_planning_parameters cpp,
2865: mtl_item_sub_inventories misi,
2866: CSP.csp_business_rules_b cbrb
2867: Where cuh.planning_parameters_id = cpp.planning_parameters_id
2868: and misi.organization_id(+) = cuh.organization_id
2869: and misi.inventory_item_id(+) = cuh.inventory_item_id
2915: sq.RECOMMENDED_MAX_QUANTITY,2);
2916: COMMIT;
2917: */
2918: FOR usg_hdr_rec in c_usg_hdr_subinv LOOP
2919: UPDATE MTL_ITEM_SUB_INVENTORIES item_subinv
2920: SET MIN_MINMAX_QUANTITY = usg_hdr_rec.RECOMMENDED_MIN_QUANTITY,
2921: MAX_MINMAX_QUANTITY = usg_hdr_rec.RECOMMENDED_MAX_QUANTITY,
2922: INVENTORY_PLANNING_CODE = 2
2923: WHERE item_subinv.INVENTORY_ITEM_ID = usg_hdr_rec.INVENTORY_ITEM_ID
2923: WHERE item_subinv.INVENTORY_ITEM_ID = usg_hdr_rec.INVENTORY_ITEM_ID
2924: and item_subinv.ORGANIZATION_ID = usg_hdr_rec.ORGANIZATION_ID
2925: and item_subinv.SECONDARY_INVENTORY = usg_hdr_rec.SECONDARY_INVENTORY;
2926: IF SQL%NOTFOUND THEN
2927: INSERT INTO MTL_ITEM_SUB_INVENTORIES
2928: (INVENTORY_ITEM_ID,
2929: ORGANIZATION_ID,
2930: SECONDARY_INVENTORY,
2931: LAST_UPDATE_DATE,