DBA Data[Home] [Help] [Dependency Information]

VIEW: APPS.XLE_FP_LEDGER_V

Object Details
Object Name: XLE_FP_LEDGER_V
Object Type: VIEW
Owner: APPS
FND Design Data: ViewXLE.XLE_FP_LEDGER_V
Subobject Name:
Status: VALID

XLE_FP_LEDGER_V view can be used to access the Business Relationship between Ledger and First Party Legal Entity. This view can be used to derive the Legal Information based on Ledger.

[View Source]

Columns
Name Datatype Length Mandatory Comments
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

Legal Entity Identifier
LEGAL_ENTITY_NAME VARCHAR2 (240) Yes Legal Entity Name
LEGAL_ENTITY_IDENTIFIER VARCHAR2 (30)
Legal Entity Identifier
LEGAL_ENTITY_COUNTRY VARCHAR2 (2)
Legal Entity Country
LE_EFFECTIVE_FROM DATE

Le Effective From
LE_EFFECTIVE_TO DATE

Le Effective To
LEDGER_CATEGORY_CODE VARCHAR2 (30) Yes Ledger Category Code
SEGMENT_VALUE VARCHAR2 (25) Yes Balancing Segment Value
START_DATE DATE

Start Date of Balancing Segment Value
END_DATE DATE

End Date of Balancing Segment Value
Query Text

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


SELECT LEDGER_ID
,      LEDGER_NAME
,      LEDGER_SHORT_NAME
,      LEGAL_ENTITY_ID
,      LEGAL_ENTITY_NAME
,      LEGAL_ENTITY_IDENTIFIER
,      LEGAL_ENTITY_COUNTRY
,      LE_EFFECTIVE_FROM
,      LE_EFFECTIVE_TO
,      LEDGER_CATEGORY_CODE
,      SEGMENT_VALUE
,      START_DATE
,      END_DATE
FROM APPS.XLE_FP_LEDGER_V;

Dependencies

[top of page]

APPS.XLE_FP_LEDGER_V references the following:

SchemaAPPS
SynonymGL_LEDGERS
SynonymGL_LEDGER_CONFIGURATIONS
SynonymGL_LEDGER_NORM_SEG_VALS
SynonymHZ_GEOGRAPHIES
SynonymXLE_ENTITY_PROFILES

APPS.XLE_FP_LEDGER_V is not referenced by any database object