--应收会计-事务处理-分配-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
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