APPS.INV_ITEM_CATALOG_ELE_PVT SQL Statements

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

Line: 58

      SELECT organization_id
      FROM  mtl_system_items_b
      WHERE  inventory_item_id = p_inventory_item_id;

Line: 65

      SELECT  element_name
      FROM  mtl_descr_element_values
      WHERE  inventory_item_id = p_inventory_item_id
      AND    element_name = p_element_name;

Line: 72

      SELECT  item_Catalog_group_id
      FROM  mtl_system_items_b
      WHERE  inventory_item_id = p_inventory_item_id
      AND    item_Catalog_group_id IS NOT NULL;

Line: 231

		Select concatenated_segments
		into l_item_number
		From mtl_system_items_b_kfv
		where INVENTORY_ITEM_ID = l_inventory_item_id
		AND organization_id = l_org_id;

Line: 241

      (  p_Msg_Name  =>'INV_IOI_ITEM_UPDATE_PRIV'
       ,  p_token     => 'VALUE'
       ,  p_value     =>  l_item_number );

Line: 249

      INV_ITEM_MSG.Debug(Mctx, 'begin UPDATE  mtl_descr_element_values');

Line: 251

      UPDATE  mtl_descr_element_values
      SET
        element_value     = p_element_value
      ,  default_element_flag = decode(p_default_element_flag,'Y','Y','N')
      ,  last_update_date  = SYSDATE
      ,  last_updated_by   = FND_GLOBAL.user_id
      ,  last_update_login = FND_GLOBAL.login_id
      ,  request_id        = FND_GLOBAL.conc_request_id
      ,  program_application_id	= FND_GLOBAL.prog_appl_id
      ,  program_id 	   = FND_GLOBAL.conc_program_id
      ,  program_update_date = SYSDATE
      WHERE
          inventory_item_id = l_inventory_item_id
      AND element_name      = p_element_name;

Line: 267

    INV_ITEM_MSG.Debug(Mctx, 'end UPDATE mtl_descr_element_values');

Line: 281

      INV_ITEM_MSG.Write_List (p_delete => TRUE);