How to get the <ACCOUNTING_FLEXFIELD> Name in a Multi Ledger Instance?
Hi,
How to get the <ACCOUNTING_FLEXFIELD> Name in a Multi Ledger
Instance with the logged-in Responsibility? Is there any profile option
available?
----
SELECT id_flex_num
INTO l_structure_num
FROM apps.fnd_id_flex_structures
WHERE ID_FLEX_CODE = 'GL#'
AND ID_FLEX_STRUCTURE_CODE=<ACCOUNTING_FLEXFIELD>;
---
Tx
----
SELECT id_flex_num
INTO l_structure_num
FROM apps.fnd_id_flex_structures
WHERE ID_FLEX_CODE = 'GL#'
AND ID_FLEX_STRUCTURE_CODE=<ACCOUNTING_FLEXFIELD>;
---
Tx
Tagged:
0