1. Tables and Views for Financials
  2. XLE_LE_FROM_REGISTRATIONS_V

XLE_LE_FROM_REGISTRATIONS_V

Details

  • Schema: FUSION

  • Object owner: XLE

  • Object type: VIEW

Columns

Name

REGISTRATION_ID

LEGISLATIVE_CATEGORY_CODE

LEGISLATIVE_CATEGORY_MEANING

REGISTRATION_NUMBER

COUNTRY_OF_REGISTRATION

TRANSACTION_TAX_REGN_CONTEXT

EFFECTIVE_FROM

EFFECTIVE_TO

LEGAL_ENTITY_ID

LEGAL_ENTITY_NAME

Query

SQL_Statement

(

SELECT r.REGISTRATION_ID,

lkp.LOOKUP_CODE LEGISLATIVE_CATEGORY_CODE,

lkp.MEANING LEGISLATIVE_CATEGORY_MEANING,

r.REGISTRATION_NUMBER REGISTRATION_NUMBER,

rgm.COUNTRY_CODE COUNTRY_OF_REGISTRATION,

r.TAX_REGIME_CODE || DECODE(r.TAX, NULL, NULL, '-' || r.TAX) TRANSACTION_TAX_REGN_CONTEXT,

r.EFFECTIVE_FROM EFFECTIVE_FROM,

r.EFFECTIVE_TO EFFECTIVE_TO,

e.LEGAL_ENTITY_ID LEGAL_ENTITY_ID,

e.NAME LEGAL_ENTITY_NAME

FROM ZX_REGISTRATIONS r,

ZX_PARTY_TAX_PROFILE p,

XLE_ETB_PROFILES e,

ZX_REGIMES_B rgm,

HZ_LOOKUPS lkp

WHERE r.PARTY_TAX_PROFILE_ID = p.PARTY_TAX_PROFILE_ID

AND p.PARTY_TYPE_CODE = 'LEGAL_ESTABLISHMENT'

AND p.PARTY_ID = e.PARTY_ID

AND r.TAX_REGIME_CODE = rgm.TAX_REGIME_CODE

AND lkp.LOOKUP_TYPE = 'LEGISLATIVE_CATEGORY'

AND lkp.LOOKUP_CODE = 'TRANSACTION_TAX'

UNION

SELECT r.REGISTRATION_ID,

lkp.LOOKUP_CODE LEGISLATIVE_CATEGORY_CODE,

lkp.MEANING LEGISLATIVE_CATEGORY_MEANING,

r.REGISTRATION_NUMBER,

g.GEOGRAPHY_CODE COUNTRY_OF_REGISTRATION,

NULL TRANSACTION_TAX_REGN_CONTEXT,

r.EFFECTIVE_FROM,

r.EFFECTIVE_TO,

e.LEGAL_ENTITY_ID,

e.NAME LEGAL_ENTITY_NAME

FROM XLE_REGISTRATIONS r,

XLE_ENTITY_PROFILES e,

XLE_JURISDICTIONS_B j,

HZ_GEOGRAPHIES g,

HZ_LOOKUPS lkp

WHERE r.SOURCE_ID = e.LEGAL_ENTITY_ID

AND r.SOURCE_TABLE = 'XLE_ENTITY_PROFILES'

AND r.JURISDICTION_ID = j.JURISDICTION_ID

AND j.GEOGRAPHY_ID = g.GEOGRAPHY_ID

AND lkp.LOOKUP_TYPE = 'LEGISLATIVE_CATEGORY'

AND lkp.LOOKUP_CODE = j.LEGISLATIVE_CAT_CODE)