VRM_OPERATING_UNITS_V

Details

• Schema: FUSION

• Object owner: VRM

• Object type: VIEW

Columns

Name
ORG_ID ORGANIZATION_NAME DEFAULT_LEDGER_ID DEFAULT_LEDGER_NAME DEFAULT_LEGAL_ENTITY_ID DEFAULT_LEGAL_ENTITY_NAME DEFAULT_LEGAL_ENTITY_COUNTRY DEFAULT_LEGAL_ENTITY_ADDRESS

Query

SQL_Statement

SELECT fbu.bu_id org_id, fbu.bu_NAME organization_name, fbu.primary_ledger_id default_ledger_id, gll.NAME default_ledger_name, xle.legal_entity_id default_legal_entity_id, xle.NAME default_legal_entity_name, NULL default_legal_entity_country, NULL default_legal_entity_address FROM fun_all_business_units_v fbu, xle_entity_profiles xle, gl_ledgers gll WHERE fbu.legal_entity_id = xle.legal_entity_id AND fbu.PRIMARY_LEDGER_ID = gll.ledger_id