弹性域中数据查询

  --应收会计-事务处理-分配-GL 账户-部门段
  select * from gl.gl_code_combinations gcc WHERE gcc.code_combination_id = 1157 --弹性域字段组合表
  
  select * from FND_FLEX_VALUES_VL fvl WHERE fvl.DESCRIPTION LIKE '国际业务一部'
  
  SELECT fvl.description
    FROM fnd_flex_values_vl fvl,--弹性域表 
         fnd_flex_value_sets fvs--值集表‘EWPT_COA_CC’
   WHERE fvs.flex_value_set_id = fvl.flex_value_set_id
     AND fvs.flex_value_set_name = 'EWPT_COA_CC'
     AND nvl(fvl.enabled_flag, 'N') = 'Y'
     --AND fvl.flex_value = gcc.segment5--gcc.segment5：产品门类段
     AND fvl.flex_value = gcc.segment2--add by wrh 20140227 gcc.segment2:部门段
     AND nvl(fvl.end_date_active, SYSDATE + 1) > SYSDATE
     and rownum<2