[Home] [Help] [Dependency Information]

TABLE: GL.GL_XFR_LEDGERS

Object Details

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

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
GL_XFR_LEDGERS_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	NAME
GL_XFR_LEDGERS_U2	NORMAL	UNIQUE	APPS_TS_TX_IDX	LEDGER_ID
GL_XFR_LEDGERS_N1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	CHART_OF_ACCOUNTS_ID PERIOD_SET_NAME ACCOUNTED_PERIOD_TYPE
GL_XFR_LEDGERS_N2	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	BAL_SEG_VALUE_SET_ID
GL_XFR_LEDGERS_N3	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	MGT_SEG_VALUE_SET_ID

Columns

Query Text

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

SELECT LEDGER_ID
,      NAME
,      SHORT_NAME
,      DESCRIPTION
,      LEDGER_CATEGORY_CODE
,      ALC_LEDGER_TYPE_CODE
,      OBJECT_TYPE_CODE
,      LE_LEDGER_TYPE_CODE
,      COMPLETION_STATUS_CODE
,      CONFIGURATION_ID
,      CHART_OF_ACCOUNTS_ID
,      CURRENCY_CODE
,      PERIOD_SET_NAME
,      ACCOUNTED_PERIOD_TYPE
,      FIRST_LEDGER_PERIOD_NAME
,      RET_EARN_CODE_COMBINATION_ID
,      SUSPENSE_ALLOWED_FLAG
,      ALLOW_INTERCOMPANY_POST_FLAG
,      TRACK_ROUNDING_IMBALANCE_FLAG
,      ENABLE_AVERAGE_BALANCES_FLAG
,      CUM_TRANS_CODE_COMBINATION_ID
,      RES_ENCUMB_CODE_COMBINATION_ID
,      NET_INCOME_CODE_COMBINATION_ID
,      ROUNDING_CODE_COMBINATION_ID
,      ENABLE_BUDGETARY_CONTROL_FLAG
,      REQUIRE_BUDGET_JOURNALS_FLAG
,      ENABLE_JE_APPROVAL_FLAG
,      ENABLE_AUTOMATIC_TAX_FLAG
,      CONSOLIDATION_LEDGER_FLAG
,      TRANSLATE_EOD_FLAG
,      TRANSLATE_QATD_FLAG
,      TRANSLATE_YATD_FLAG
,      TRANSACTION_CALENDAR_ID
,      DAILY_TRANSLATION_RATE_TYPE
,      AUTOMATICALLY_CREATED_FLAG
,      BAL_SEG_VALUE_OPTION_CODE
,      BAL_SEG_COLUMN_NAME
,      MGT_SEG_VALUE_OPTION_CODE
,      MGT_SEG_COLUMN_NAME
,      BAL_SEG_VALUE_SET_ID
,      MGT_SEG_VALUE_SET_ID
,      IMPLICIT_ACCESS_SET_ID
,      CRITERIA_SET_ID
,      FUTURE_ENTERABLE_PERIODS_LIMIT
,      LEDGER_ATTRIBUTES
,      IMPLICIT_LEDGER_SET_ID
,      LATEST_OPENED_PERIOD_NAME
,      LATEST_ENCUMBRANCE_YEAR
,      PERIOD_AVERAGE_RATE_TYPE
,      PERIOD_END_RATE_TYPE
,      BUDGET_PERIOD_AVG_RATE_TYPE
,      BUDGET_PERIOD_END_RATE_TYPE
,      SLA_ACCOUNTING_METHOD_CODE
,      SLA_ACCOUNTING_METHOD_TYPE
,      SLA_DESCRIPTION_LANGUAGE
,      SLA_ENTERED_CUR_BAL_SUS_CCID
,      SLA_SEQUENCING_FLAG
,      SLA_BAL_BY_LEDGER_CURR_FLAG
,      SLA_LEDGER_CUR_BAL_SUS_CCID
,      ENABLE_SECONDARY_TRACK_FLAG
,      ENABLE_REVAL_SS_TRACK_FLAG
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_LOGIN
,      ATTRIBUTE_CATEGORY
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
,      ENABLE_RECONCILIATION_FLAG
,      CREATE_JE_FLAG
,      SLA_LEDGER_CASH_BASIS_FLAG
,      COMPLETE_FLAG
,      OBJECT_VERSION_NUMBER
,      USSGL_OPTION_CODE
,      VALIDATE_JOURNAL_REF_DATE
,      JRNLS_GROUP_BY_DATE_FLAG
,      REVAL_FROM_PRI_LGR_CURR
,      AUTOREV_AFTER_OPEN_PRD_FLAG
,      PRIOR_PRD_NOTIFICATION_FLAG
,      POP_UP_STAT_ACCOUNT_FLAG
,      THRESHOLD_AMOUNT
,      NUMBER_OF_PROCESSORS
,      PROCESSING_UNIT_SIZE
,      RELEASE_UPGRADE_FROM
,      CROSS_LGR_CLR_ACC_CCID
,      INTERCO_GAIN_LOSS_CCID
,      ATTRIBUTE_NUMBER1
,      ATTRIBUTE_NUMBER2
,      ATTRIBUTE_NUMBER3
,      ATTRIBUTE_NUMBER4
,      ATTRIBUTE_NUMBER5
,      ATTRIBUTE_DATE1
,      ATTRIBUTE_DATE2
,      ATTRIBUTE_DATE3
,      ATTRIBUTE_DATE4
,      ATTRIBUTE_DATE5
FROM GL.GL_XFR_LEDGERS;

Dependencies

[top of page]

GL.GL_XFR_LEDGERS does not reference any database object

GL.GL_XFR_LEDGERS is referenced by following:

GL

GL_XFR_LEDGERS#