1. Tables and Views for Sales and Fusion Service
  2. OKC_CURRENT_USER_BU_V

OKC_CURRENT_USER_BU_V

Details

  • Schema: FUSION

  • Object owner: OKC

  • 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 exists

(select 1

from FUN_BU_USAGES buusage

where buusage.business_unit_id = bu.BU_ID

and module_id in ('90', '180')

)

and

bu_id IN (SELECT * FROM THE( SELECT Cast(SPLIT_INTO_TABLE(HZ_SESSION_UTIL.GET_USER_BUSINESS_UNITS ) AS VARCHAR2_TABLE) FROM Dual ) )