Wednesday, July 3, 2024

Query to get functional currency of Business Unit

 Query to get functional currency of Business Unit


SELECT gs.currency_code, ho.name FROM gl_sets_of_books gs, ar_system_parameters_all os, hr_operating_units ho WHERE OS.SET_OF_BOOKS_ID = GS.SET_OF_BOOKS_ID and HO.name = '<BUSSINESS UNIT NAME>' AND ho.organization_id = os.org_id;

No comments:

Post a Comment

EBS : Package Development Process

====================== Package Specification ================================== CREATE OR REPLACE PACKAGE xx_emp_package IS     PROCEDURE lo...