1. Tables and Views for Financials
  2. XLE_LE_OU_LEDGER_V

XLE_LE_OU_LEDGER_V

Details

  • Schema: FUSION

  • Object owner: XLE

  • Object type: VIEW

Columns

Name

OPERATING_UNIT_ID

LEDGER_ID

LEDGER_NAME

LEDGER_SHORT_NAME

LEGAL_ENTITY_ID

LEGAL_ENTITY_NAME

LEGAL_ENTITY_IDENTIFIER

ACTIVITY_CODE

SUB_ACTIVITY_CODE

TYPE_OF_COMPANY

LE_EFFECTIVE_FROM

LE_EFFECTIVE_TO

REGISTRATION_NUMBER

ADDRESS_LINE_1

ADDRESS_LINE_2

ADDRESS_LINE_3

REGION_1

REGION_2

REGION_3

TOWN_OR_CITY

POSTAL_CODE

COUNTRY

Query

SQL_Statement

SELECT BU.BU_ID OPERATING_UNIT_ID,

lg.LEDGER_ID ,

lg.NAME LEDGER_NAME ,

lg.SHORT_NAME LEDGER_SHORT_NAME ,

cfgDet.OBJECT_ID LEGAL_ENTITY_ID ,

xlep.name legal_entity_name,

xlep.legal_entity_identifier,

xlep.activity_code,

xlep.sub_activity_code,

xlep.type_of_company,

xlep.effective_from le_effective_from,

xlep.effective_to le_effective_to,

reg.registration_number,

hrl.address_line_1,

hrl.address_line_2,

hrl.address_line_3,

hrl.region_1,

hrl.region_2,

hrl.region_3,

hrl.town_or_city,

hrl.postal_code,

hrl.country

FROM GL_LEDGERS primaryLg ,

GL_LEDGERS lg ,

GL_LEDGER_RELATIONSHIPS rs ,

GL_LEDGER_CONFIGURATIONS cfg ,

GL_LEDGER_CONFIG_DETAILS cfgDet,

XLE_ENTITY_PROFILES xlep,

XLE_REGISTRATIONS reg,

XLE_LOCATIONS_V hrl,

FUN_ALL_BUSINESS_UNITS_V bu

WHERE rs.application_id = 101

AND ( ( rs.target_ledger_category_code = 'SECONDARY' AND rs.relationship_type_code <> 'NONE' )

OR ( rs.target_ledger_category_code = 'PRIMARY' AND rs.relationship_type_code = 'NONE' )

OR ( rs.target_ledger_category_code = 'ALC' AND rs.relationship_type_code IN ( 'JOURNAL', 'SUBLEDGER') ) )

AND lg.ledger_id = rs.target_ledger_id

AND lg.ledger_category_code = rs.target_ledger_category_code

AND primaryLg.ledger_id = rs.primary_ledger_id

AND primaryLg.ledger_category_code = 'PRIMARY'

AND cfg.configuration_id = primaryLg.configuration_id

AND cfgDet.configuration_id (+) = cfg.configuration_id

AND cfgDet.object_type_code (+) = 'LEGAL_ENTITY'

AND cfgDet.object_id = xlep.legal_entity_id

AND xlep.legal_entity_id = reg.source_id

AND reg.source_table = 'XLE_ENTITY_PROFILES'

AND reg.identifying_flag = 'Y'

AND reg.location_id = hrl.location_id

AND BU.primary_ledger_id = to_char(lg.LEDGER_ID)

AND BU.STATUS = 'A'

AND xlep.transacting_entity_flag = 'Y'