336: SELECT msi.lot_control_code
337: , msi.serial_number_control_code
338: INTO v_lot_control_code
339: , v_serial_control_code
340: FROM mtl_system_items msi, mtl_material_transactions_temp mmtt
341: WHERE msi.inventory_item_id = mmtt.inventory_item_id
342: AND msi.organization_id = mmtt.organization_id
343: AND mmtt.transaction_temp_id = p_temp_id;
344:
934: l_org_id := mmt_row.organization_id;
935:
936: --Bug#5010991. Get the PRIMARY_UOM_CODE for the item.
937: SELECT msi.primary_uom_code INTO l_item_uom_code
938: FROM mtl_system_items msi
939: WHERE msi.inventory_item_id=l_item_id
940: AND msi.organization_id=l_org_id;
941:
942:
1176: SELECT lot_control_code
1177: , serial_number_control_code
1178: INTO v_lot_control_code
1179: , v_serial_control_code
1180: FROM mtl_system_items
1181: WHERE inventory_item_id = l_item_id
1182: AND organization_id = l_org_id;
1183:
1184: IF (l_debug = 1) THEN
1683: INTO v_rev_control_code
1684: , v_lot_control_code
1685: , v_serial_control_code
1686: , l_uom
1687: FROM mtl_system_items
1688: WHERE inventory_item_id = mmtt_table(cnt).inventory_item_id
1689: AND organization_id = mmtt_table(cnt).organization_id;
1690: EXCEPTION
1691: WHEN OTHERS THEN