764:
765: -- Calculate the tag quantity at standard uom
766: SELECT primary_uom_code
767: INTO l_item_standard_uom
768: FROM mtl_system_items
769: WHERE inventory_item_id = p_inventory_item_id
770: AND organization_id = p_organization_id;
771: -- I assume that the primary_uom_code is always given for an item
772: l_tag_qty_at_standard_uom := inv_convert.inv_um_convert
946: END IF;
947: -- Calculate the tag quantity at standard uom
948: SELECT primary_uom_code
949: INTO l_item_standard_uom
950: FROM mtl_system_items
951: WHERE inventory_item_id = p_inventory_item_id
952: AND organization_id = p_organization_id;
953: -- I assume that the primary_uom_code is always given for an item
954: l_tag_qty_at_standard_uom := inv_convert.inv_um_convert
1120: print_debug('Get the primary UOM code: ' || 'Item ID: ' || l_inventory_item_id || ': ' || 'Org ID: ' || p_organization_id);
1121: END IF;
1122: SELECT primary_uom_code
1123: INTO l_standard_uom_code
1124: FROM mtl_system_items
1125: WHERE inventory_item_id = l_inventory_item_id
1126: AND organization_id = p_organization_id;
1127:
1128: -- Call the label printing API if an adjustment is required
1251: SELECT revision_qty_control_code, location_control_code,
1252: lot_control_code, serial_number_control_code
1253: INTO l_rev_code, l_location_control_code,
1254: l_lot_control_code, l_serial_control_code
1255: FROM mtl_system_items
1256: WHERE inventory_item_id = p_inventory_item_id
1257: AND organization_id = p_organization_id;
1258:
1259: -- Get the adjustment ID if it is existing
1478: IF (v_lpn_id.inventory_item_id IS NOT NULL) THEN
1479: -- Get the primary UOM for the container inventory item
1480: SELECT primary_uom_code
1481: INTO l_temp_uom_code
1482: FROM mtl_system_items
1483: WHERE inventory_item_id = v_lpn_id.inventory_item_id
1484: AND organization_id = v_lpn_id.organization_id;
1485:
1486: IF (l_debug = 1) THEN
1535: FOR v_lpn_serial_content IN lpn_serial_contents_cursor LOOP
1536: -- Get the primary UOM for the serialized item
1537: SELECT primary_uom_code
1538: INTO l_temp_uom_code
1539: FROM mtl_system_items
1540: WHERE inventory_item_id = v_lpn_serial_content.inventory_item_id
1541: AND organization_id = v_lpn_serial_content.current_organization_id;
1542:
1543: IF (l_debug = 1) THEN