1.客戶化開發(fā)中的多帳套屏蔽

(1) 得到當(dāng)前OU

mo_global.get_current_org_id或者fnd_global.org_id

(2)根據(jù)組織ID得到賬套ID和公司名稱

DECLAREl_org_information3 VARCHAR2(150); --帳套idl_company_desc VARCHAR2(150); --公司中文描述 BEGINSELECT o3.org_information3, o3.attribute3INTO l_org_information3，l_company_descFROM hr_all_organization_units o,hr_all_organization_units_tl otl,hr_organization_information o2,hr_organization_information o3WHERE o.organization_id = o2.organization_idAND o.organization_id = o3.organization_idAND o2.org_information_context || '' = 'CLASS'AND o3.org_information_context = 'Operating Unit Information'AND o2.org_information1 = 'OPERATING_UNIT'AND o2.org_information2 = 'Y'AND o.organization_id = otl.organization_idAND otl.language = userenv('LANG')AND o.organization_id = p_org_id; --OU id END;

(3) 得到本位幣

DECLAREl_local_currency_code VARCHAR2(15); --本位幣 BEGINSELECT gsob.currency_codeINTO l_local_currency_codeFROM gl_sets_of_books gsob, hr_operating_units houWHERE gsob.set_of_books_id = hou.set_of_books_idAND hou.organization_id = p_org_id; --OU ID END;

(4) 在程序中加上本位幣和賬套的限制

?

2.多帳套實(shí)現(xiàn)擴(kuò)展

--帳套定義 SELECT * FROM gl_ledgers;--賬套視圖 SELECT * FROM gl_sets_of_books;--法人定義 SELECT * FROM xle_entity_profiles;

?

轉(zhuǎn)載于:https://www.cnblogs.com/Cqiang/archive/2013/02/23/2923765.html

創(chuàng)作挑戰(zhàn)賽新人創(chuàng)作獎(jiǎng)勵(lì)來(lái)咯，堅(jiān)持創(chuàng)作打卡瓜分現(xiàn)金大獎(jiǎng)

總結(jié)

以上是生活随笔為你收集整理的ORACLE EBS 多账套总结的全部?jī)?nèi)容，希望文章能夠幫你解決所遇到的問(wèn)題。

如果覺(jué)得生活随笔網(wǎng)站內(nèi)容還不錯(cuò)，歡迎將生活随笔推薦給好友。