How to get ledger name in Oracle APPS R12


Hello,
 Oracle you can get ledger name by using below query: 


select mo_utils.Get_Ledger_Name(P_ORG_ID) from dual ;

Using ORG ID from profile value:

select mo_utils.Get_Ledger_Name( fnd_profile.value('ORG_ID')) from dual;

Using the above query in concurrent programs parameters default value for sql statement.

Thank you, 


1 comment:

  1. My spouse and I love your blog and find almost all of your posts to be just what I’m looking for. Appreciating the persistence you put into your blog and the detailed information you provide. I found another one blog like you OA Framework.Actually I was looking for the same information on internet for Oracle OAF and came across your blog. I am impressed by the information that you have on this blog. Thanks once more for all the details.

    ReplyDelete

2015@Bahaa Barghouti. Powered by Blogger.