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.XLA_LEDGER_RELATIONSHIPS_V

Object Details

Object Name:	XLA_LEDGER_RELATIONSHIPS_V
Object Type:	VIEW
Owner:	APPS
FND Design Data:	XLA.XLA_LEDGER_RELATIONSHIPS_V
Subobject Name:
Status:	VALID

* Warning: Oracle Internal Use Only *

Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.

View Type

Internal

[View Source]

Columns

Name	Datatype	Length	Mandatory
LEDGER_ID	NUMBER	(15)	Yes
TARGET_LEDGER_ID	NUMBER	(15)	Yes
SLA_LEDGER_ID	NUMBER	(15)	Yes
NAME	VARCHAR2	(30)	Yes
SHORT_NAME	VARCHAR2	(20)	Yes
PRIMARY_LEDGER_ID	NUMBER	(15)	Yes
LEDGER_CATEGORY_CODE	VARCHAR2	(30)	Yes
ENABLE_BUDGETARY_CONTROL_FLAG	VARCHAR2	(1)	Yes
CURRENCY_CODE	VARCHAR2	(15)	Yes
CHART_OF_ACCOUNTS_ID	NUMBER	(15)	Yes
SL_COA_MAPPING_ID	NUMBER	(15)
PERIOD_SET_NAME	VARCHAR2	(15)	Yes
COMPLETION_STATUS_CODE	VARCHAR2	(30)
RELATIONSHIP_TYPE_CODE	VARCHAR2	(30)	Yes
RELATIONSHIP_ENABLED_FLAG	VARCHAR2	(1)	Yes
LATEST_OPENED_PERIOD_NAME	VARCHAR2	(15)
SLA_DESCRIPTION_LANGUAGE	VARCHAR2	(15)
SLA_ACCOUNTING_METHOD_CODE	VARCHAR2	(30)
SLA_ACCOUNTING_METHOD_TYPE	VARCHAR2	(1)
SLA_ENTERED_CUR_BAL_SUS_CCID	NUMBER	(15)
BAL_SEG_COLUMN_NAME	VARCHAR2	(25)	Yes
MGT_SEG_COLUMN_NAME	VARCHAR2	(25)
SLA_BAL_BY_LEDGER_CURR_FLAG	VARCHAR2	(1)
SLA_LEDGER_CUR_BAL_SUS_CCID	NUMBER	(15)
LATEST_ENCUMBRANCE_YEAR	NUMBER	(15)
ALC_INHERIT_CONVERSION_TYPE	VARCHAR2	(1)
ALC_DEFAULT_CONV_RATE_TYPE	VARCHAR2	(30)
ALC_NO_RATE_ACTION_CODE	VARCHAR2	(30)
ALC_MAX_DAYS_ROLL_RATE	NUMBER
COMPLETE_FLAG	VARCHAR2	(1)

Query Text

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


SELECT LEDGER_ID
,      TARGET_LEDGER_ID
,      SLA_LEDGER_ID
,      NAME
,      SHORT_NAME
,      PRIMARY_LEDGER_ID
,      LEDGER_CATEGORY_CODE
,      ENABLE_BUDGETARY_CONTROL_FLAG
,      CURRENCY_CODE
,      CHART_OF_ACCOUNTS_ID
,      SL_COA_MAPPING_ID
,      PERIOD_SET_NAME
,      COMPLETION_STATUS_CODE
,      RELATIONSHIP_TYPE_CODE
,      RELATIONSHIP_ENABLED_FLAG
,      LATEST_OPENED_PERIOD_NAME
,      SLA_DESCRIPTION_LANGUAGE
,      SLA_ACCOUNTING_METHOD_CODE
,      SLA_ACCOUNTING_METHOD_TYPE
,      SLA_ENTERED_CUR_BAL_SUS_CCID
,      BAL_SEG_COLUMN_NAME
,      MGT_SEG_COLUMN_NAME
,      SLA_BAL_BY_LEDGER_CURR_FLAG
,      SLA_LEDGER_CUR_BAL_SUS_CCID
,      LATEST_ENCUMBRANCE_YEAR
,      ALC_INHERIT_CONVERSION_TYPE
,      ALC_DEFAULT_CONV_RATE_TYPE
,      ALC_NO_RATE_ACTION_CODE
,      ALC_MAX_DAYS_ROLL_RATE
,      COMPLETE_FLAG
FROM APPS.XLA_LEDGER_RELATIONSHIPS_V;