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]

TABLE: GL.GL_LEDGER_RELATIONSHIPS

Object Details

Object Name:	GL_LEDGER_RELATIONSHIPS
Object Type:	TABLE
Owner:	GL
FND Design Data:	SQLGL.GL_LEDGER_RELATIONSHIPS
Subobject Name:
Status:	VALID

GL_LEDGER_RELATIONSHIPS stores the relationships between ledgers. Each relationship between a primary ledger and a secondary ledger or between a ledger and its reporting currency is stored in one or more rows in this table. GL_LEDGER_RELATIONSHIPS also stores the chart of accounts mapping, conversion, and initialization rules necessary to convert data from the source ledger to its secondary ledger or reporting currency. For upgrade cases, it may contain multiple rows for a single relationship; one row per application or per operating unit for which that relationship is maintained. GL_LEDGER_RELATIONSHIPS also always contains one "self" row for each ledger and for each subledger or journal level reporting currency, even if that ledger has no relationships defined for it.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
GL_LEDGER_RELATIONSHIPS_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	RELATIONSHIP_ID
GL_LEDGER_RELATIONSHIPS_U2	NORMAL	UNIQUE	APPS_TS_TX_IDX	SOURCE_LEDGER_ID TARGET_LEDGER_CATEGORY_CODE RELATIONSHIP_TYPE_CODE TARGET_LEDGER_ID TARGET_CURRENCY_CODE PRIMARY_LEDGER_ID APPLICATION_ID ORG_ID
GL_LEDGER_RELATIONSHIPS_N1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	PRIMARY_LEDGER_ID TARGET_LEDGER_CATEGORY_CODE
GL_LEDGER_RELATIONSHIPS_N2	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	TARGET_LEDGER_ID SOURCE_LEDGER_ID TARGET_LEDGER_NAME TARGET_LEDGER_SHORT_NAME
GL_LEDGER_RELATIONSHIPS_N3	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	TARGET_LEDGER_SHORT_NAME

Columns

Name	Datatype	Length	Mandatory	Comments
RELATIONSHIP_ID	NUMBER	(15)	Yes	Relationship defining column
SOURCE_LEDGER_ID	NUMBER	(15)	Yes	Ledger identifier where reporting currency conversions are based from transactions/journals/balances
TARGET_LEDGER_ID	NUMBER	(15)	Yes	Destination ledger defining column for conversion of transactions/journals/balances
SLA_LEDGER_ID	NUMBER	(15)	Yes	Ledger identifier in the subledger transactions used for creating subledger accounting entries
PRIMARY_LEDGER_ID	NUMBER	(15)	Yes	Ledger identifier of the primary ledger as defined in the accounting configuration
TARGET_CURRENCY_CODE	VARCHAR2	(15)	Yes	Target ledger currency code
TARGET_LEDGER_NAME	VARCHAR2	(30)	Yes	Target ledger name
TARGET_LEDGER_SHORT_NAME	VARCHAR2	(20)	Yes	Target ledger short name
TARGET_LEDGER_CATEGORY_CODE	VARCHAR2	(30)	Yes	Target ledger category (PRIMARY, SECONDARY, ALC etc)
RELATIONSHIP_TYPE_CODE	VARCHAR2	(30)	Yes	Relationship level between source and target ledger
RELATIONSHIP_ENABLED_FLAG	VARCHAR2	(1)	Yes	Enabled flag
INHERIT_CREATION_USER_FLAG	VARCHAR2	(1)	Yes	Inherit creation flag
LAST_UPDATE_DATE	DATE		Yes	Standard Who column
LAST_UPDATED_BY	NUMBER	(15)	Yes	Standard Who column
CREATION_DATE	DATE		Yes	Standard Who column
CREATED_BY	NUMBER	(15)	Yes	Standard Who column
LAST_UPDATE_LOGIN	NUMBER	(15)		Standard Who column
GL_JE_CONVERSION_SET_ID	NUMBER	(15)		Journal conversion rules identifier
SL_COA_MAPPING_ID	NUMBER	(15)		Key flexfield structure defining column
AUTOMATIC_POST_FLAG	VARCHAR2	(1)		Automatic posting flag
ALC_DEFAULT_CONV_RATE_TYPE	VARCHAR2	(30)		Default conversion rate type for reporting ledger journal
ALC_NO_RATE_ACTION_CODE	VARCHAR2	(30)		When no rate exists report error or use last available rate
ALC_MAX_DAYS_ROLL_RATE	NUMBER			Maximum roll days allowed for a conversion rate
ALC_INHERIT_CONVERSION_TYPE	VARCHAR2	(1)		Inherit conversion rate type from transaction, i.e. do not use the default ALC_DEFAULT_CONV_RATE_TYPE
ALC_INIT_CONV_OPTION_CODE	VARCHAR2	(30)		Historical conversion option (Derive, Initialize)
ALC_INIT_PERIOD	VARCHAR2	(15)		First accounting period for reporting currency
ALC_INIT_DATE	DATE			First accounting date for reporting currency
ALC_INITIALIZING_RATE_DATE	DATE			Rate date used for initializing historical transactions/balances
ALC_INITIALIZING_RATE_TYPE	VARCHAR2	(30)		Rate type used for initializing historical transactions/balances
ALC_PERIOD_AVERAGE_RATE_TYPE	VARCHAR2	(30)		Reporting currency period average rate type
ALC_PERIOD_END_RATE_TYPE	VARCHAR2	(30)		Reporting currency period end rate type
APPLICATION_ID	NUMBER	(15)		Application defining column (backward compatible only)
ORG_ID	NUMBER	(15)		Operating unit defining column (backward compatible only)
DISABLE_CONVERSION_DATE	DATE			Disable conversion date
STATUS_CODE	VARCHAR2	(30)		Status code
HIST_CONV_STATUS_CODE	VARCHAR2	(30)		Historical Conversion Status Code

Query Text

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


SELECT RELATIONSHIP_ID
,      SOURCE_LEDGER_ID
,      TARGET_LEDGER_ID
,      SLA_LEDGER_ID
,      PRIMARY_LEDGER_ID
,      TARGET_CURRENCY_CODE
,      TARGET_LEDGER_NAME
,      TARGET_LEDGER_SHORT_NAME
,      TARGET_LEDGER_CATEGORY_CODE
,      RELATIONSHIP_TYPE_CODE
,      RELATIONSHIP_ENABLED_FLAG
,      INHERIT_CREATION_USER_FLAG
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_LOGIN
,      GL_JE_CONVERSION_SET_ID
,      SL_COA_MAPPING_ID
,      AUTOMATIC_POST_FLAG
,      ALC_DEFAULT_CONV_RATE_TYPE
,      ALC_NO_RATE_ACTION_CODE
,      ALC_MAX_DAYS_ROLL_RATE
,      ALC_INHERIT_CONVERSION_TYPE
,      ALC_INIT_CONV_OPTION_CODE
,      ALC_INIT_PERIOD
,      ALC_INIT_DATE
,      ALC_INITIALIZING_RATE_DATE
,      ALC_INITIALIZING_RATE_TYPE
,      ALC_PERIOD_AVERAGE_RATE_TYPE
,      ALC_PERIOD_END_RATE_TYPE
,      APPLICATION_ID
,      ORG_ID
,      DISABLE_CONVERSION_DATE
,      STATUS_CODE
,      HIST_CONV_STATUS_CODE
FROM GL.GL_LEDGER_RELATIONSHIPS;

Dependencies

[top of page]

GL.GL_LEDGER_RELATIONSHIPS does not reference any database object

GL.GL_LEDGER_RELATIONSHIPS is referenced by following:

GL: GL_LEDGER_RELATIONSHIPS#