APPS.WMS_PICK_LOAD_UI SQL Statements

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

Line: 287

   select ENABLE_LOCATOR_ALIAS INTO l_alias_enabled
   from MTL_SECONDARY_INVENTORIES
   where SECONDARY_INVENTORY_NAME = p_subinventory_code
   and ORGANIZATION_ID = p_organization_id;

Line: 297

          select concatenated_segments INTO l_locator_lpn
          from wms_item_locations_kfv
          where concatenated_segments =  p_locator_lpn
            and SUBINVENTORY_CODE = p_subinventory_code
            and ORGANIZATION_ID = p_organization_id;

Line: 306

         select concatenated_segments INTO l_locator_lpn
         from wms_item_locations_kfv
         where alias = p_locator_lpn
           and SUBINVENTORY_CODE = p_subinventory_code
           and ORGANIZATION_ID = p_organization_id;

Line: 432

      SELECT Decode(lpn_controlled_flag, 1, 'Y', 'N')
        INTO x_is_lpn_controlled
        FROM mtl_secondary_inventories
        WHERE organization_id = p_organization_id
        AND secondary_inventory_name = x_subinventory_code;