eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

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

VIEW: APPS.XLE_REGISTRATIONS_V

Object Details

Object Name:	XLE_REGISTRATIONS_V
Object Type:	VIEW
Owner:	APPS
FND Design Data:	XLE.XLE_REGISTRATIONS_V
Subobject Name:
Status:	VALID

XLE_REGISTRATIONS_V view provides information about Registrations that are Identifying and Non-Identifying. Additionally, the user can access the Legal Authority Information related to the Registration.

[View Source]

Columns

Name	Datatype	Length	Comments
LEGAL_ENTITY_ID	NUMBER		Legal Entity ID of the LE to which Registration is associated to .Value NULL if the Registration is associated to an Establishment
LEGAL_ENTITY_NAME	VARCHAR2	(240)	Legal Entity Name of the LE to which Registration is associated to. Value NULL if the Registration is associated to an Establishment
PARTY_ID	NUMBER		Party id of the LE to which Registration is associated. Value NULL if the Registration is associated to an Establishment
ESTABLISHMENT_ID	NUMBER		Establishment ID of the Establishment to which the Registration is associated.Value NULL if the Registration is associated to a LE
ESTABLISHMENT_NAME	VARCHAR2	(240)	Establishment Name of the Establishment to which the Registration is associated.Value NULL if the Registration is associated to a LE
ESTABLISHMENT_PARTY_ID	NUMBER		Establishment Name of the Establishment to which the Registration is associated.Value NULL if the Registration is associated to a LE
REGISTRATION_ID	NUMBER	(15)	Registration ID of the Registration
REGISTRATION_NUMBER	VARCHAR2	(30)	Registration Number of the Registration
REGISTERED_NAME	VARCHAR2	(240)	Registered Name of the Registration
ALTERNATE_REGISTERED_NAME	VARCHAR2	(240)	Alternate Registered Name of the Registration
IDENTIFYING	VARCHAR2	(1)	Identifying Flag. Value Y for Identifying Registrations and Value N for Non-Identifying Registrations
LEGISLATIVE_CATEGORY	VARCHAR2	(30)	Legislative Category
LEGALAUTH_ID	NUMBER	(15)	Issuing Legal Authority Identifier
LEGALAUTH_NAME	VARCHAR2	(360)	Issuing Legal Authority Name
LEGALAUTH_ADDRESS	VARCHAR2	(725)	Issuing Legal Authority Address
EFFECTIVE_FROM	DATE		Registration Start Date
EFFECTIVE_TO	DATE		Registration End Date
LOCATION_ID	NUMBER	(15)	Location Identifier
ADDRESS_STYLE	VARCHAR2	(7)	Registered Address: Address Style
ADDRESS_LINE_1	VARCHAR2	(240)	Registered Address: Address Line 1
ADDRESS_LINE_2	VARCHAR2	(240)	Registered Address: Address Line 2
ADDRESS_LINE_3	VARCHAR2	(240)	Registered Address: Address Line 3
TOWN_OR_CITY	VARCHAR2	(30)	Registered Address: Town Or City
REGION_1	VARCHAR2	(120)	Registered Address: Region 1
REGION_2	VARCHAR2	(120)	Registered Address: Region 2
REGION_3	VARCHAR2	(120)	Registered Address: Region 3
POSTAL_CODE	VARCHAR2	(30)	Registered Address: Postal Code
COUNTRY	VARCHAR2	(60)	Registered Address: Country

Query Text

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


SELECT LEGAL_ENTITY_ID
,      LEGAL_ENTITY_NAME
,      PARTY_ID
,      ESTABLISHMENT_ID
,      ESTABLISHMENT_NAME
,      ESTABLISHMENT_PARTY_ID
,      REGISTRATION_ID
,      REGISTRATION_NUMBER
,      REGISTERED_NAME
,      ALTERNATE_REGISTERED_NAME
,      IDENTIFYING
,      LEGISLATIVE_CATEGORY
,      LEGALAUTH_ID
,      LEGALAUTH_NAME
,      LEGALAUTH_ADDRESS
,      EFFECTIVE_FROM
,      EFFECTIVE_TO
,      LOCATION_ID
,      ADDRESS_STYLE
,      ADDRESS_LINE_1
,      ADDRESS_LINE_2
,      ADDRESS_LINE_3
,      TOWN_OR_CITY
,      REGION_1
,      REGION_2
,      REGION_3
,      POSTAL_CODE
,      COUNTRY
FROM APPS.XLE_REGISTRATIONS_V;

Dependencies

[top of page]

APPS.XLE_REGISTRATIONS_V references the following:

APPS: HR_LOCATIONS_ALL; HZ_LOCATIONS; HZ_PARTIES; HZ_PARTY_SITES; XLE_ENTITY_PROFILES; XLE_ETB_PROFILES; XLE_JURISDICTIONS_VL; XLE_REGISTRATIONS

APPS.XLE_REGISTRATIONS_V is referenced by following:

APPS: JE_JEITAPEX_XMLP_PKG - show dependent code; JE_JEITXLRG_XMLP_PKG - show dependent code; JE_ZZ_AUDIT_AP_PKG - show dependent code; JG_TAXID_VAL_PKG - show dependent code; JG_ZZ_RGRH_PKG - show dependent code