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_LE_OU_LEDGER_V

Object Details

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

XLE_LE_OU_LEDGER_V view can be used to access the Business Relationship between Operating Unit, Ledger and Legal Entity. This view can be used to derive the Legal Information based on Operating Unit / Ledger.

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
OPERATING_UNIT_ID	NUMBER	(15)	Yes	Operating Unit Identifier
LEDGER_ID	NUMBER	(15)	Yes	Ledger Identifier
LEDGER_NAME	VARCHAR2	(30)	Yes	Ledger Name
LEDGER_SHORT_NAME	VARCHAR2	(20)	Yes	Ledger Short Name
LEGAL_ENTITY_ID	NUMBER	(15)		Legal Entity Internal Identifier
LEGAL_ENTITY_NAME	VARCHAR2	(240)	Yes	Legal Entity Name
LEGAL_ENTITY_IDENTIFIER	VARCHAR2	(30)		Tax Registration Number orUnique LE identifier
ACTIVITY_CODE	VARCHAR2	(150)		Activity Code of the Legal Entity
SUB_ACTIVITY_CODE	VARCHAR2	(150)		Sub-Activity Code of the Legal Entity
TYPE_OF_COMPANY	VARCHAR2	(50)		Type Of Company of the Legal Entity
LE_EFFECTIVE_FROM	DATE			Start Date of Legal Entity Registration (Identifying)
LE_EFFECTIVE_TO	DATE			End Date of Legal Entity Registration (Identifying)
REGISTRATION_NUMBER	VARCHAR2	(30)	Yes	Registration Number of the Identifying Registration of the Legal Entity
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
REGION_1	VARCHAR2	(120)		Legal Address: Region 1
REGION_2	VARCHAR2	(120)		Legal Address: Region 2
REGION_3	VARCHAR2	(120)		Legal Address: Region 3
TOWN_OR_CITY	VARCHAR2	(30)		Legal Address: Town Or City
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 OPERATING_UNIT_ID
,      LEDGER_ID
,      LEDGER_NAME
,      LEDGER_SHORT_NAME
,      LEGAL_ENTITY_ID
,      LEGAL_ENTITY_NAME
,      LEGAL_ENTITY_IDENTIFIER
,      ACTIVITY_CODE
,      SUB_ACTIVITY_CODE
,      TYPE_OF_COMPANY
,      LE_EFFECTIVE_FROM
,      LE_EFFECTIVE_TO
,      REGISTRATION_NUMBER
,      ADDRESS_LINE_1
,      ADDRESS_LINE_2
,      ADDRESS_LINE_3
,      REGION_1
,      REGION_2
,      REGION_3
,      TOWN_OR_CITY
,      POSTAL_CODE
,      COUNTRY
FROM APPS.XLE_LE_OU_LEDGER_V;

Dependencies

[top of page]

APPS.XLE_LE_OU_LEDGER_V references the following:

APPS: GL_LEDGERS; GL_LEDGER_CONFIGURATIONS; GL_LEDGER_CONFIG_DETAILS; GL_LEDGER_RELATIONSHIPS; HR_LOCATIONS_ALL; HR_ORGANIZATION_INFORMATION; XLE_ENTITY_PROFILES; XLE_REGISTRATIONS

APPS.XLE_LE_OU_LEDGER_V is referenced by following:

APPS: ARP_LEGAL_ENTITY_UTIL - show dependent code; AR_INTEREST_HEADERS_V; AR_INVOICE_UTILS - show dependent code; IGI_RPI_STANDING_CHARGES_V; OKL_OPEN_INTERFACE_PVT - show dependent code