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_ESTABLISHMENT_V

Object Details

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

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

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
ESTABLISHMENT_ID	NUMBER	(15)	Yes	Establishment Identifier
ESTABLISHMENT_NAME	VARCHAR2	(240)	Yes	Establishment Name
PARTY_ID	NUMBER	(15)	Yes	Party Identifier of the Establishment
LEGAL_ENTITY_ID	NUMBER	(15)		Legal Entity Identifier to which the Establishment is associated
MAIN_ESTABLISHMENT_FLAG	VARCHAR2	(1)		Indicates whether an Establishment is main Establishment or Not. Y for Main Establishments and N for Other Establishments
ACTIVITY_CODE	VARCHAR2	(150)		Activity Code of Establishment
SUB_ACTIVITY_CODE	VARCHAR2	(150)		Sub-Activity Code of Establishment
REGISTRATION_NUMBER	VARCHAR2	(30)	Yes	Registration Number of the Identifying Registration
IDENTIFYING_FLAG	VARCHAR2	(1)		Identifying Flag
LEGISLATIVE_CAT_CODE	VARCHAR2	(30)	Yes	Legislative Category Code of Identifying Registration
EFFECTIVE_FROM	DATE			Start Date of Establishment Registration (Identifying)
EFFECTIVE_TO	DATE			End Date of Establishment Registration (Identifying)
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 ESTABLISHMENT_ID
,      ESTABLISHMENT_NAME
,      PARTY_ID
,      LEGAL_ENTITY_ID
,      MAIN_ESTABLISHMENT_FLAG
,      ACTIVITY_CODE
,      SUB_ACTIVITY_CODE
,      REGISTRATION_NUMBER
,      IDENTIFYING_FLAG
,      LEGISLATIVE_CAT_CODE
,      EFFECTIVE_FROM
,      EFFECTIVE_TO
,      ADDRESS_LINE_1
,      ADDRESS_LINE_2
,      TOWN_OR_CITY
,      REGION_1
,      POSTAL_CODE
,      COUNTRY
FROM APPS.XLE_FP_ESTABLISHMENT_V;

Dependencies

[top of page]

APPS.XLE_FP_ESTABLISHMENT_V references the following:

APPS: HR_LOCATIONS_ALL; XLE_ENTITY_PROFILES; XLE_ETB_PROFILES; XLE_JURISDICTIONS_VL; XLE_REGISTRATIONS

APPS.XLE_FP_ESTABLISHMENT_V is referenced by following:

APPS: ZX_TRL_ESL_VAT_NO_V; ZX_TRN_VALIDATION_PKG - show dependent code