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_FIRSTPARTY_INFORMATION_V

Object Details

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

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

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
LEGAL_ENTITY_ID	NUMBER	(15)	Yes	Legal Entity Identifier
LE_INFORMATION_CONTEXT	VARCHAR2	(30)		Developer Flexfield Segment Context
NAME	VARCHAR2	(240)	Yes	Name
PARTY_ID	NUMBER	(15)	Yes	Party Identifier
LEGAL_ENTITY_IDENTIFIER	VARCHAR2	(30)		Tax Payer ID or a dummy registration number
ACTIVITY_CODE	VARCHAR2	(150)		Activity Code
SUB_ACTIVITY_CODE	VARCHAR2	(150)		Sub Activity Code
TYPE_OF_COMPANY	VARCHAR2	(50)		Type Of Company
ACTIVITY_CATEGORY	VARCHAR2	(60)		Activity Category
ACTIVITY_DESCRIPTION	VARCHAR2	(80)		Activity Description
LE_EFFECTIVE_FROM	DATE			Start date of Legal Entity
LE_EFFECTIVE_TO	DATE			Start date of Legal Entity
ATTRIBUTE_CATEGORY	VARCHAR2	(30)		Descriptive Flexfield structure definition
ATTRIBUTE1	VARCHAR2	(150)		Descriptive Flexfield segment 1
ATTRIBUTE2	VARCHAR2	(150)		Descriptive Flexfield segment 2
ATTRIBUTE3	VARCHAR2	(150)		Descriptive Flexfield segment 3
ATTRIBUTE4	VARCHAR2	(150)		Descriptive Flexfield segment 4
ATTRIBUTE5	VARCHAR2	(150)		Descriptive Flexfield segment 5
ATTRIBUTE6	VARCHAR2	(150)		Descriptive Flexfield segment 6
ATTRIBUTE7	VARCHAR2	(150)		Descriptive Flexfield segment 7
ATTRIBUTE8	VARCHAR2	(150)		Descriptive Flexfield segment 8
ATTRIBUTE9	VARCHAR2	(150)		Descriptive Flexfield segment 9
ATTRIBUTE10	VARCHAR2	(150)		Descriptive Flexfield segment 10
ATTRIBUTE11	VARCHAR2	(150)		Descriptive Flexfield segment 11
ATTRIBUTE12	VARCHAR2	(150)		Descriptive Flexfield segment 12
ATTRIBUTE13	VARCHAR2	(150)		Descriptive Flexfield segment 13
ATTRIBUTE14	VARCHAR2	(150)		Descriptive Flexfield segment 14
ATTRIBUTE15	VARCHAR2	(150)		Descriptive Flexfield segment 15
ATTRIBUTE16	VARCHAR2	(150)		Descriptive Flexfield segment 16
ATTRIBUTE17	VARCHAR2	(150)		Descriptive Flexfield segment 17
ATTRIBUTE18	VARCHAR2	(150)		Descriptive Flexfield segment 18
ATTRIBUTE19	VARCHAR2	(150)		Descriptive Flexfield segment 19
ATTRIBUTE20	VARCHAR2	(150)		Descriptive Flexfield segment 20
REGISTRATION_NUMBER	VARCHAR2	(30)	Yes	Registration Number of the Identifying Registration
LEGISLATIVE_CAT_CODE	VARCHAR2	(30)	Yes	Legislative Category Code of Identifying Registration
EFFECTIVE_FROM	DATE			Start Date of Legal Entity Registration (Identifying)
EFFECTIVE_TO	DATE			End date of a Legal Entity Registration ( Identifying)
LOCATION_ID	NUMBER	(15)		Location ID validated against HR_LOCATIONS
ADDRESS_STYLE	VARCHAR2	(7)		Legal Address: Address Style used for this formatting Address from Region_2,Region_2,Region_3 etc.
ADDRESS_LINE_1	VARCHAR2	(240)		Legal Address: Address Line 1
ADDRESS_LINE_2	VARCHAR2	(240)		Legal Address: Address Line 2
ADDRESS_LINE_3	VARCHAR2	(240)		Legal Address: Address Line 3
TOWN_OR_CITY	VARCHAR2	(30)		Legal Address: Town Or City
REGION_1	VARCHAR2	(120)		Legal Address: Region 1
REGION_2	VARCHAR2	(120)		Legal Address: Region 2
REGION_3	VARCHAR2	(120)		Legal Address: Region 3
POSTAL_CODE	VARCHAR2	(30)		Legal Address: Postal Code
COUNTRY	VARCHAR2	(60)		Legal Address: Country

Query Text

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


SELECT LEGAL_ENTITY_ID
,      LE_INFORMATION_CONTEXT
,      NAME
,      PARTY_ID
,      LEGAL_ENTITY_IDENTIFIER
,      ACTIVITY_CODE
,      SUB_ACTIVITY_CODE
,      TYPE_OF_COMPANY
,      ACTIVITY_CATEGORY
,      ACTIVITY_DESCRIPTION
,      LE_EFFECTIVE_FROM
,      LE_EFFECTIVE_TO
,      ATTRIBUTE_CATEGORY
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
,      ATTRIBUTE16
,      ATTRIBUTE17
,      ATTRIBUTE18
,      ATTRIBUTE19
,      ATTRIBUTE20
,      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_FIRSTPARTY_INFORMATION_V;

Dependencies

[top of page]

APPS.XLE_FIRSTPARTY_INFORMATION_V references the following:

APPS: AR_LOOKUPS; FND_DESCR_FLEX_COLUMN_USAGES; FND_FLEX_VALUE_SETS; HR_LOCATIONS_ALL; XLE_ENTITY_PROFILES; XLE_JURISDICTIONS_B; XLE_REGISTRATIONS

APPS.XLE_FIRSTPARTY_INFORMATION_V is referenced by following:

APPS: ARP_CHARGEBACK_COVER - show dependent code; BIS_MONTHS_V; BIS_QUARTERS_V; BIS_YEARS_V; BOM_CSTGILEV_XMLP_PKG - show dependent code; BOM_CSTRACCR_XMLP_PKG - show dependent code; BOM_CSTRPACQ_XMLP_PKG - show dependent code; BOM_CSTRPDSS_XMLP_PKG - show dependent code; BOM_CSTRPICR_XMLP_PKG - show dependent code; BOM_CSTRPMDD_XMLP_PKG - show dependent code; BOM_CSTRPWRO_XMLP_PKG - show dependent code; CE_FC_AMTS_DISC_V; CE_FC_BANK_BAL_DISC_V; CE_XLA_EXT_HEADERS_V; CSTBV_LE_COST_TYPES; CSTFV_COST_GROUPS; CSTFV_LE_COST_TYPES; CSTFV_PAC_PERIODS; CSTPMRGL - show dependent code; CST_EAM_WORKORDERS_PVT - show dependent code; CST_LE_COST_TYPES_V; CST_MGD_LIFO_ITEM_COSTS_V; CST_MGD_LIFO_PERIODS_V; CST_MTL_RCV_TXN_V; CST_PAC_LEGAL_ENTITIES_V; CST_PAC_WIP_TXN_V; FUN_IC_AME_WF_PKG - show dependent code; FUN_OPEN_INTERFACE_PKG - show dependent code; FUN_TCA_PKG - show dependent code; FUN_TRX_ENTRY_UTIL - show dependent code; FUN_TRX_PUB - show dependent code; FUN_TRX_PVT - show dependent code; FUN_WEBADI_PKG - show dependent code; FV_SYSTEM_PARAMETERS_V; IBY_DISBURSEMENT_COMP_PUB - show dependent code; IBY_DISBURSEMENT_COMP_PUB - show dependent code; IBY_EXTRACTGEN_PVT - show dependent code; IBY_EXT_FD_PAYER_1_0_V; IBY_FD_EXTRACT_GEN_PVT - show dependent code; IBY_FD_USER_API_PUB - show dependent code; IBY_PAYGROUP_PUB - show dependent code; IBY_PP_FIRST_PARTY_V; INV_MGD_MVT_UTILS_PKG - show dependent code; JE_ES_WHTAX - show dependent code; JE_JEITAPEX_XMLP_PKG - show dependent code; JE_JEITXLRG_XMLP_PKG - show dependent code; JG_JGZZARIN_XMLP_PKG - show dependent code; JG_JGZZGLJRB_XMLP_PKG - show dependent code; JG_JGZZGLJRN_XMLP_PKG - show dependent code; JG_JGZZRCAK_XMLP_PKG - show dependent code; JG_ZZ_PTCE_DT_PKG - show dependent code; JG_ZZ_RTCE_DT_PKG - show dependent code; JG_ZZ_RTCE_DT_PKG - show dependent code; JG_ZZ_SUMMARY_ALL_PKG - show dependent code; JG_ZZ_VAT_PRE_REP_PROC_PKG - show dependent code; JG_ZZ_VAT_SELECTION_PKG - show dependent code; JL_AR_DOC_NUMBERING_PKG - show dependent code; JL_CO_GL_MG_MEDIA_PKG - show dependent code; JL_JGZZGLTRB_XMLP_PKG - show dependent code; JL_JLCLGCAL_XMLP_PKG - show dependent code; JL_JLCOARCR_XMLP_PKG - show dependent code; JL_JLCOGLAM_XMLP_PKG - show dependent code; JL_JLCOGLAN_XMLP_PKG - show dependent code; JL_JLCOGLNA_XMLP_PKG - show dependent code; JL_JLCOGLNM_XMLP_PKG - show dependent code; JL_JLZZPSSR_XMLP_PKG - show dependent code; LNS_REP_UTILS - show dependent code; MTL_FISCAL_CAT_ACCOUNTS_V; MTL_LE_ECONOMIC_ZONES_V; MTL_STAT_TYPE_USAGES_V; XLE_UTILITIES_GRP - show dependent code; ZX_DEFAULT_AUTOMATION_PKG - show dependent code; ZX_EXTRACT_PKG - show dependent code; ZX_TCM_CONTROL_PKG - show dependent code; ZX_VALIDATE_API_PKG - show dependent code