Oracle EBS 查询会计分录信息SQL
ALTER SESSION SET NLS_LANGUAGE='SIMPLIFIED CHINESE';
SELECT
gcc.segment1 ,gl_flexfields_pkg.get_description_sql(&char_of_account_id,1,gcc.segment1) seg1,
gcc.segment2 ,gl_flexfields_pkg.get_description_sql(&char_of_account_id,2,gcc.segment2) seg2,
gcc.segment3,gl_flexfields_pkg.get_description_sql(&char_of_account_id,3,gcc.segment3) seg3,
gcc.segment4,gl_flexfields_pkg.get_description_sql(&char_of_account_id,4,gcc.segment4) seg4,
gcc.segment5,gl_flexfields_pkg.get_description_sql(&char_of_account_id,5,gcc.segment5) seg5,
gcc.segment6,gl_flexfields_pkg.get_description_sql(&char_of_account_id,6,gcc.segment6) seg6,
gcc.segment7,gl_flexfields_pkg.get_description_sql(&char_of_account_id,7,gcc.segment7) seg7,
gcc.segment8,gl_flexfields_pkg.get_description_sql(&char_of_account_id,8,gcc.segment8) seg8
FROM gl_code_combinations gcc
WHERE gcc.code_combination_id = &code_combination_id;
-- 刘轶鹤