OSS_CURRENT_USER_BU_V
Details
-
Schema: FUSION
-
Object owner: OSS
-
Object type: VIEW
Columns
Name |
---|
BU_ID BU_NAME LOCATION_ID BUSINESS_GROUP_ID DATE_FROM DATE_TO MANAGER_ID LEGAL_ENTITY_ID PRIMARY_LEDGER_ID DEFAULT_SET_ID SHORT_CODE ENABLED_FOR_HR_FLAG FIN_BUSINESS_UNIT_ID DEFAULT_CURRENCY_CODE STATUS |
Query
SQL_Statement |
---|
select bu_id, bu_name, location_id, business_group_id, date_from, date_to, manager_id, legal_entity_id, primary_ledger_id, default_set_id, short_code, enabled_for_hr_flag, fin_business_unit_id, default_currency_code, status from fun_all_business_units_v bu where bu_id IN (SELECT * FROM THE( SELECT Cast(SPLIT_INTO_TABLE(HZ_SESSION_UTIL.GET_USER_BUSINESS_UNITS ) AS VARCHAR2_TABLE) FROM Dual ) ) |