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_OU_LEDGER_V

Object Details

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

XLE_FP_OU_LEDGER_V view can be used to access the Business Relationship between Operating Unit, Ledger and First Party 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 Identifier
LEGAL_ENTITY_NAME	VARCHAR2	(240)	Yes	Legal Entity Name
LEGAL_ENTITY_IDENTIFIER	VARCHAR2	(30)		Legal Entity Identifier
ACTIVITY_CODE	VARCHAR2	(150)		Activity Code of Legal Entity
SUB_ACTIVITY_CODE	VARCHAR2	(150)		Sub-Activity Code of Legal Entity
TYPE_OF_COMPANY	VARCHAR2	(50)		Type Of Company of Legal Entity
LE_EFFECTIVE_FROM	DATE			Start Date of of Legal Entity
LE_EFFECTIVE_TO	DATE			End Date of of Legal Entity
REGISTRATION_NUMBER	VARCHAR2	(30)	Yes	Registration Number of the Identifying Registration associated to the Legal Entity
ADDRESS_LINE_1	VARCHAR2	(240)		Registration Address: Address Line 1
ADDRESS_LINE_2	VARCHAR2	(240)		Registration Address: Address Line 2
ADDRESS_LINE_3	VARCHAR2	(240)		Registration Address: Address Line 3
REGION_1	VARCHAR2	(120)		Registration Address: Region 1
REGION_2	VARCHAR2	(120)		Registration Address: Region 2
REGION_3	VARCHAR2	(120)		Registration Address: Region 3
TOWN_OR_CITY	VARCHAR2	(30)		Registration Address: Town Or City
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 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_FP_OU_LEDGER_V;

Dependencies

[top of page]

APPS.XLE_FP_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_FP_OU_LEDGER_V is referenced by following:

APPS: CEP_STANDARD - show dependent code; CE_AUTO_BANK_MATCH - show dependent code; INL_LANDEDCOST_PVT - show dependent code; JAI_FBT_PAYMENT_P - show dependent code; JAI_FBT_PROCESS_P - show dependent code; JAI_FBT_SETTLEMENT_P - show dependent code; XLA_JOURNAL_ENTRIES_PKG - show dependent code; XLE_UTILITIES_GRP - show dependent code