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_ESTABLISHMENT_V

Object Details

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

XLE_ESTABLISHMENT_V view provides the user with information related to Establishments related to Legal Entities. The view encompasses both First Party and Third Party LEs. End Dates are not discriminated and hence, user has the access to Inactive Legal Entities and Establishments as well.

[View Source]

Columns

Name	Datatype	Length	Comments
ESTABLISHMENT_ID	NUMBER	(15)	Establishment Identifier
ESTABLISHMENT_NAME	VARCHAR2	(240)	Establishment Name
PARTY_ID	NUMBER	(15)	Party Identifier for the Establishment. Foreign key to the HZ_PARTIES table
LEGAL_ENTITY_ID	NUMBER	(15)	Identifier of the Legal Entity that owns the Establishment. Foreign key to the XLE_ENTITY_PROFILES table
MAIN_ESTABLISHMENT_FLAG	VARCHAR2	(1)	Main Establishment Flag
ACTIVITY_CODE	VARCHAR2	(150)	Activity Code of Establishment
SUB_ACTIVITY_CODE	VARCHAR2	(150)	Sub-Activity Code of Establishment
TYPE_OF_COMPANY	VARCHAR2	(50)	Type of Company of Establishment
ETB_EFFECTIVE_FROM	DATE		Effective From of the Establishment
ETB_EFFECTIVE_TO	DATE		Effective To of the Establishment
REGISTRATION_NUMBER	VARCHAR2	(30)	Registration Number of the Identifying Registration associated to the Establishment
LEGISLATIVE_CAT_CODE	VARCHAR2	(30)	Legislative Category of the Registration
EFFECTIVE_FROM	DATE		Effective from of the Registration
EFFECTIVE_TO	DATE		Effective To of the Registration
LOCATION_ID	NUMBER		Establishment Address: Location ID
ADDRESS_STYLE	VARCHAR2	(7)	Establishment Address: Address Style
ADDRESS_LINE_1	VARCHAR2	(240)	Establishment Address: Address Line 1
ADDRESS_LINE_2	VARCHAR2	(240)	Establishment Address: Address Line 2
ADDRESS_LINE_3	VARCHAR2	(240)	Establishment Address: Address Line 3
TOWN_OR_CITY	VARCHAR2	(30)	Establishment Address: Town Or City
REGION_1	VARCHAR2	(120)	Establishment Address: Region 1
REGION_2	VARCHAR2	(120)	Establishment Address: Region 2
REGION_3	VARCHAR2	(120)	Establishment Address: Region 3
POSTAL_CODE	VARCHAR2	(30)	Establishment Address: Postal Code
COUNTRY	VARCHAR2	(60)	Establishment Address: Country

Query Text

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


SELECT ESTABLISHMENT_ID
,      ESTABLISHMENT_NAME
,      PARTY_ID
,      LEGAL_ENTITY_ID
,      MAIN_ESTABLISHMENT_FLAG
,      ACTIVITY_CODE
,      SUB_ACTIVITY_CODE
,      TYPE_OF_COMPANY
,      ETB_EFFECTIVE_FROM
,      ETB_EFFECTIVE_TO
,      REGISTRATION_NUMBER
,      LEGISLATIVE_CAT_CODE
,      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_ESTABLISHMENT_V;

Dependencies

[top of page]

APPS.XLE_ESTABLISHMENT_V references the following:

APPS: HR_LOCATIONS_ALL; XLE_ETB_PROFILES; XLE_JURISDICTIONS_VL; XLE_REGISTRATIONS

APPS.XLE_ESTABLISHMENT_V is referenced by following:

APPS: JL_BR_AP_VALIDATE_COLLECTION - show dependent code; JL_BR_AR_LOG_VALIDATION - show dependent code; JL_BR_WORKDAY_CALENDAR - show dependent code; JL_JLBRRCAD_XMLP_PKG - show dependent code; JL_ZZ_AP_LIBRARY_1_PKG - show dependent code