Protected by Copyscape Web Copyright Protection Software

Search This Blog

Tuesday, April 4, 2017

How to get ledger name?

Hi,

In Oracle you can get ledger name by using below query.

select mo_utils.Get_Ledger_Name(P_ORG_ID) from dual
Org_id from profile.

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

you can use above query in conc prg parameters default value for sql statement.

No comments:

Post a Comment