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_FP_REGISTRATIONS_V

Object Details

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

XLE_FP_ESTABLISHMENT_V view provides the users with access to all First Party Legal Entity Registration Information. This includes the related Identifying Jurisdiction. End Dates are not discriminated and hence, user has the access to Inactive Establishments as well.

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
LEGAL_ENTITY_ID	NUMBER	(15)	Yes	Legal Entity Identifier
LEGAL_ENTITY_NAME	VARCHAR2	(240)	Yes	Legal Entity Name
PARTY_ID	NUMBER	(15)	Yes	Legal Entity Party Identifier
REGISTRATION_NUMBER	VARCHAR2	(30)	Yes	Registration Number
IDENTIFYING	VARCHAR2	(1)		Identifying Flag of the Jurisdiction
LEGISLATIVE_CATEGORY	VARCHAR2	(30)	Yes	Legislative Category
LEGALAUTH_NAME	VARCHAR2	(360)		Legal Authority Name
LEGALAUTH_ADDRESS	VARCHAR2	(725)		Legal Authority Address
EFFECTIVE_FROM	DATE			Start Date of Legal Entity Registration
EFFECTIVE_TO	DATE			End Date of Legal Entity Registration
ADDRESS_LINE_1	VARCHAR2	(240)		Registration Address: Address Line 1
ADDRESS_LINE_2	VARCHAR2	(240)		Registration Address: Address Line 2
TOWN_OR_CITY	VARCHAR2	(30)		Registration Address: Town Or City
REGION_1	VARCHAR2	(120)		Registration Address: Region 1
POSTAL_CODE	VARCHAR2	(30)		Registration Address: Postal Code
COUNTRY	VARCHAR2	(60)		Registration Address: Country

Query Text

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


SELECT LEGAL_ENTITY_ID
,      LEGAL_ENTITY_NAME
,      PARTY_ID
,      REGISTRATION_NUMBER
,      IDENTIFYING
,      LEGISLATIVE_CATEGORY
,      LEGALAUTH_NAME
,      LEGALAUTH_ADDRESS
,      EFFECTIVE_FROM
,      EFFECTIVE_TO
,      ADDRESS_LINE_1
,      ADDRESS_LINE_2
,      TOWN_OR_CITY
,      REGION_1
,      POSTAL_CODE
,      COUNTRY
FROM APPS.XLE_FP_REGISTRATIONS_V;

Dependencies

[top of page]

APPS.XLE_FP_REGISTRATIONS_V references the following:

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

APPS.XLE_FP_REGISTRATIONS_V is not referenced by any database object