DBA Data[Home] [Help] [Dependency Information]

VIEW: APPS.XLE_LE_FROM_REGISTRATIONS_V

Object Details
Object Name: XLE_LE_FROM_REGISTRATIONS_V
Object Type: VIEW
Owner: APPS
FND Design Data: ViewXLE.XLE_LE_FROM_REGISTRATIONS_V
Subobject Name:
Status: VALID

XLE_LE_FROM_REGISTRATIONS_V view provides the users with access to all Legal Entity Registration Information

[View Source]

Columns
Name Datatype Length Mandatory Comments
REGISTRATION_ID NUMBER (15)
Registration Identifier
LEGISLATIVE_CATEGORY_CODE VARCHAR2 (30)
Legislative Category Code
LEGISLATIVE_CATEGORY_MEANING VARCHAR2 (80)
Legislative Category of the Registration
REGISTRATION_NUMBER VARCHAR2 (50)
Registration Number of the Registration
COUNTRY_OF_REGISTRATION VARCHAR2 (30)
Country Of Registration
TRANSACTION_TAX_REGN_CONTEXT VARCHAR2 (61)
Transaction Tax Registration Context
EFFECTIVE_FROM DATE

Registration Start Date
EFFECTIVE_TO DATE

Registration End Date
LEGAL_ENTITY_ID NUMBER (15)
Legal Entity Identifier
LEGAL_ENTITY_NAME VARCHAR2 (240)
Legal Entity Name
Query Text

Cut, paste (and edit) the following text to query this object:


SELECT 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
FROM APPS.XLE_LE_FROM_REGISTRATIONS_V;

Dependencies

[top of page]

APPS.XLE_LE_FROM_REGISTRATIONS_V references the following:

SchemaAPPS
ViewAR_LOOKUPS
SynonymHZ_GEOGRAPHIES
SynonymXLE_ENTITY_PROFILES
SynonymXLE_ETB_PROFILES
SynonymXLE_JURISDICTIONS_B
SynonymXLE_REGISTRATIONS
SynonymZX_PARTY_TAX_PROFILE
SynonymZX_REGIMES_B
SynonymZX_REGISTRATIONS

APPS.XLE_LE_FROM_REGISTRATIONS_V is not referenced by any database object