APPS.INV_TABLE_LOCK_PVT SQL Statements

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

Line: 29

      SELECT count(1) into l_neg_exists
      FROM mtl_onhand_quantities_detail
     WHERE organization_id = p_organization_id
       AND inventory_item_id = p_inventory_item_id
       AND subinventory_code like p_subinventory
       AND nvl(lot_number,'@@@') like nvl(p_lot,'@@@')
       AND nvl(revision,'@@@') like nvl(p_revision,'@@@')
       AND nvl(locator_id,-999) = nvl(p_locator,-999)
       AND primary_transaction_quantity < 0
       AND rownum < 2;

Line: 45

/*	 select USERENV('SESSIONID') into l_sessionid from dual;

Line: 67

        insert into mtl_onhand_lock_temp(LOCK_HANDLE) values(l_lock_handle);

Line: 90

   INSERT INTO mtl_onhand_lock_temp(
         lock_handle
       , header_id)
   VALUES (
         x_lock_handle
       , p_header_id);

Line: 143

    select lock_handle bulk collect into table_handle from mtl_onhand_lock_temp;

Line: 161

	DELETE MTL_ONHAND_LOCK_TEMP;

Line: 188

        DELETE mtl_onhand_lock_temp
        WHERE header_id = p_header_id;

Line: 192

      SELECT lock_handle
      BULK COLLECT INTO table_handle
      FROM mtl_onhand_lock_temp
      WHERE header_id = p_header_id;

Line: 216

        DELETE mtl_onhand_lock_temp
        WHERE header_id = p_header_id;