需求:
创建或者查找现在账户ID ,需要通过一下三个步骤:
1. 得到账簿的CHART_OF_ACCOUNTS_ID
2. 得到账户弹性域分隔符
3. 调用标准的API得到账户组合id
具体实现如下:
1. 得到账簿的CHART_OF_ACCOUNTS_ID实现code:
SELECT sob.chart_of_accounts_id
INTO l_chart_of_accounts_id
FROM financials_system_params_all fsp, gl_sets_of_books sob
WHERE org_id = p_org_id
AND sob.set_of_books_id = fsp.set_of_books_id;
2. 得到账户弹性域分隔符实现code:
SELECT concatenated_segment_delimiter
INTO l_segment_delimiter
FROM fnd_id_flex_structures
WHERE