change flexvalue set 的值

chenbinglan

select *From FND_ID_FLEXS where id_flex_name='Accounting Flexfield'; ; Accounting Flexfield   INTERCOMPANY
select *From FND_ID_FLEX_STRUCTURES_VL where id_flex_code='GL#' and id_flex_structure_code='DLC_ACCOUNTING_FLEX';   
select *from FND_ID_FLEX_SEGMENTS_VL  where id_flex_code='GL#' and id_flex_Num=50469;
select *From FND_FLEX_VALUES_VL where flex_value_set_id=1008190 ;
SELECT *fROM FND_FLEX_VALUES_VL where flex_value_set_id=1008190 AND flex_value='CM_SSDL' ;
UPDATE  FND_FLEX_VALUES_VL SET  flex_value='TEST' where flex_value_set_id=1008190 AND flex_value='CM_SSDL' ;

SELECT *fROM FND_FLEX_VALUES where flex_value_set_id=1008190 AND flex_value='TEST' ;
UPDATE  FND_FLEX_VALUES SET  flex_value='TEST' where flex_value_set_id=1008190 AND flex_value='CM_SSDL'