Select description from
fnd_flex_values_vl
where flex_Value = <segment value>
and flex_value_set_id = < enter the value set id >
Select GCC.CONCATENATED_SEGMENTS ACCOUNT
,GL_FLEXFIELDS_PKG.GET_CONCAT_DESCRIPTION(GCC.CHART _OF_ACCOUNTS_ID,GCC.CODE_COMBINATION_ID) DESCRIPTION
from GL_CODE_COMBINATIONS_KFV GCC
fnd_flex_values_vl
where flex_Value = <segment value>
and flex_value_set_id = < enter the value set id >
Select GCC.CONCATENATED_SEGMENTS ACCOUNT
,GL_FLEXFIELDS_PKG.GET_CONCAT_DESCRIPTION(GCC.CHART _OF_ACCOUNTS_ID,GCC.CODE_COMBINATION_ID) DESCRIPTION
from GL_CODE_COMBINATIONS_KFV GCC
来自 “ ITPUB博客 ” ，链接：https://blog.itpub.net/13975809/viewspace-2131652/ ，如需转载，请注明出处，否则将追究法律责任。
上一篇：
ORCLE 数据库中一些常用的表
下一篇：
temp table
请登录后发表评论
登录
全部评论
