APPS.WMS_OVERPICK SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 73

   SELECT organization_id, subinventory_code, locator_id, inventory_item_id, revision, lot_number
     INTO l_org_id, l_sub, l_loc_id, l_item_id, l_revision, l_lot
     FROM mtl_material_transactions_temp
     WHERE transaction_temp_id = p_temp_id;

Line: 78

   SELECT lot_control_code, revision_qty_control_code, serial_number_control_code, primary_uom_code
     INTO l_lot_control_code, l_revision_qty_control_code, l_serial_number_control_code, l_primary_uom
     from mtl_system_items
     where inventory_item_id = l_item_id AND organization_id = l_org_id;