1、通过账户查找ccid
fnd_flex_ext.get_ccid(application_short_name => 'SQLGL',
key_flex_code => 'GL#',
structure_number => l_char_id, --SELECT CHART_OF_ACCOUNTS_ID FROM GL_SETS_OF_BOOKS
validation_date => to_char(SYSDATE,
'YYYY-MM-DD'),
concatenated_segments => l_account) --科目账户fnd_flex_ext.get_ccid(applica