565: l_item_unit_weight
566: , l_weight_uom_code
567: , l_primary_uom_code
568: FROM
569: MTL_SYSTEM_ITEMS muc
570: WHERE muc.inventory_item_id = p_inventory_item_id
571: AND muc.organization_id = p_organization_id;
572:
573: IF (l_primary_uom_code IS NOT NULL
944: IS
945: SELECT
946: sic.category_id
947: FROM
948: MTL_SYSTEM_ITEMS si
949: , MTL_ITEM_CATEGORIES sic
950: WHERE si.inventory_item_id = sic.inventory_item_id
951: AND si.organization_id = sic.organization_id
952: AND si.inventory_item_id = p_movement_Transaction.inventory_item_id