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_SETS_OF_BOOKS_11I

Object Details

Object Name:	GL_SETS_OF_BOOKS_11I
Object Type:	TABLE
Owner:	GL
FND Design Data:	SQLGL.GL_SETS_OF_BOOKS_11I
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.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
GL_SETS_OF_BOOKS_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	NAME
GL_SETS_OF_BOOKS_U2	NORMAL	UNIQUE	APPS_TS_TX_IDX	SET_OF_BOOKS_ID

Columns

Name	Datatype	Length	Mandatory	Comments
SET_OF_BOOKS_ID	NUMBER	(15)	Yes	Accounting books defining column
NAME	VARCHAR2	(30)	Yes	Accounting books name
SHORT_NAME	VARCHAR2	(20)	Yes	Accounting books short name
CHART_OF_ACCOUNTS_ID	NUMBER	(15)	Yes	Key flexfield structure defining column
CURRENCY_CODE	VARCHAR2	(15)	Yes	Currency
PERIOD_SET_NAME	VARCHAR2	(15)	Yes	Accounting calendar name
ACCOUNTED_PERIOD_TYPE	VARCHAR2	(15)	Yes	Accounting period type
SUSPENSE_ALLOWED_FLAG	VARCHAR2	(1)	Yes	Suspense posting allowed flag
ALLOW_INTERCOMPANY_POST_FLAG	VARCHAR2	(1)	Yes	Allow intercompany posting
TRACK_ROUNDING_IMBALANCE_FLAG	VARCHAR2	(1)	Yes	Track rounding imbalances flag
ENABLE_AVERAGE_BALANCES_FLAG	VARCHAR2	(1)	Yes	Enable average balances flag
ENABLE_BUDGETARY_CONTROL_FLAG	VARCHAR2	(1)	Yes	Enable budgetary control flag
REQUIRE_BUDGET_JOURNALS_FLAG	VARCHAR2	(1)	Yes	Journal required for budget flag
ENABLE_JE_APPROVAL_FLAG	VARCHAR2	(1)	Yes	Enable journal entry approval flag
ENABLE_AUTOMATIC_TAX_FLAG	VARCHAR2	(1)	Yes	Enable automatic tax flag
CONSOLIDATION_SOB_FLAG	VARCHAR2	(1)	Yes	Consolidation set of books flag
TRANSLATE_EOD_FLAG	VARCHAR2	(1)	Yes	Translate EOD balances flag
TRANSLATE_QATD_FLAG	VARCHAR2	(1)	Yes	Translated QATD balances flag
TRANSLATE_YATD_FLAG	VARCHAR2	(1)	Yes	Translate YATD balances flag
MRC_SOB_TYPE_CODE	VARCHAR2	(1)	Yes	MRC set of books type (Parent, Reporting, None)
ALLOW_POSTING_WARNING_FLAG	VARCHAR2	(1)	Yes	No longer used - (defaults to 'N')
LAST_UPDATE_DATE	DATE		Yes	Standard Who column
LAST_UPDATED_BY	NUMBER	(15)	Yes	Standard Who column
CREATION_DATE	DATE			Standard Who column
CREATED_BY	NUMBER	(15)		Standard Who column
LAST_UPDATE_LOGIN	NUMBER	(15)		Standard Who column
FUTURE_ENTERABLE_PERIODS_LIMIT	NUMBER	(15)		Number of future enterable periods
LATEST_OPENED_PERIOD_NAME	VARCHAR2	(15)		Latest opened accounting period
LATEST_ENCUMBRANCE_YEAR	NUMBER	(15)		Latest open year for encumbrances
RET_EARN_CODE_COMBINATION_ID	NUMBER	(15)		Retained earnings key flexfield defining column
CUM_TRANS_CODE_COMBINATION_ID	NUMBER	(15)		Cumulative translation adjustment key flexfield defining column
RES_ENCUMB_CODE_COMBINATION_ID	NUMBER	(15)		Reserve for encumbrance key flexfield defining column
NET_INCOME_CODE_COMBINATION_ID	NUMBER	(15)		Net income key flexfield defining column
ROUNDING_CODE_COMBINATION_ID	NUMBER	(15)		Rounding imbalances key flexfield defining column
TRANSACTION_CALENDAR_ID	NUMBER	(15)		Transaction Calendar defining column
DAILY_TRANSLATION_RATE_TYPE	VARCHAR2	(30)		The rate type to be used for translation of average balances
EARLIEST_UNTRANS_PERIOD_NAME	VARCHAR2	(15)		No longer used
DESCRIPTION	VARCHAR2	(240)		Accounting books description
ATTRIBUTE1	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE2	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE3	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE4	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE5	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE6	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE7	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE8	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE9	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE10	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE11	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE12	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE13	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE14	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE15	VARCHAR2	(150)		Descriptive flexfield segment
CONTEXT	VARCHAR2	(150)		Descriptive flexfield context
GLOBAL_ATTRIBUTE_CATEGORY	VARCHAR2	(30)		Reserved for country-specific functionality
GLOBAL_ATTRIBUTE1	VARCHAR2	(150)		Reserved for country-specific functionality
GLOBAL_ATTRIBUTE2	VARCHAR2	(150)		Reserved for country-specific functionality
GLOBAL_ATTRIBUTE3	VARCHAR2	(150)		Reserved for country-specific functionality
GLOBAL_ATTRIBUTE4	VARCHAR2	(150)		Reserved for country-specific functionality
GLOBAL_ATTRIBUTE5	VARCHAR2	(150)		Reserved for country-specific functionality
GLOBAL_ATTRIBUTE6	VARCHAR2	(150)		Reserved for country-specific functionality
GLOBAL_ATTRIBUTE7	VARCHAR2	(150)		Reserved for country-specific functionality
GLOBAL_ATTRIBUTE8	VARCHAR2	(150)		Reserved for country-specific functionality
GLOBAL_ATTRIBUTE9	VARCHAR2	(150)		Reserved for country-specific functionality
GLOBAL_ATTRIBUTE10	VARCHAR2	(150)		Reserved for country-specific functionality
TRACK_ENTERED_FUNC_CURR_FLAG	VARCHAR2	(1)		Oracle Internal use only - reserved for future use
ENABLE_SECONDARY_TRACK_FLAG	VARCHAR2	(1)		Oracle Internal use only - reserved for future use
ENABLE_REVAL_SS_TRACK_FLAG	VARCHAR2	(1)		Oracle Internal use only - reserved for future use
BAL_SEG_COLUMN_NAME	VARCHAR2	(30)		Reserved for future use

Query Text

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


SELECT SET_OF_BOOKS_ID
,      NAME
,      SHORT_NAME
,      CHART_OF_ACCOUNTS_ID
,      CURRENCY_CODE
,      PERIOD_SET_NAME
,      ACCOUNTED_PERIOD_TYPE
,      SUSPENSE_ALLOWED_FLAG
,      ALLOW_INTERCOMPANY_POST_FLAG
,      TRACK_ROUNDING_IMBALANCE_FLAG
,      ENABLE_AVERAGE_BALANCES_FLAG
,      ENABLE_BUDGETARY_CONTROL_FLAG
,      REQUIRE_BUDGET_JOURNALS_FLAG
,      ENABLE_JE_APPROVAL_FLAG
,      ENABLE_AUTOMATIC_TAX_FLAG
,      CONSOLIDATION_SOB_FLAG
,      TRANSLATE_EOD_FLAG
,      TRANSLATE_QATD_FLAG
,      TRANSLATE_YATD_FLAG
,      MRC_SOB_TYPE_CODE
,      ALLOW_POSTING_WARNING_FLAG
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_LOGIN
,      FUTURE_ENTERABLE_PERIODS_LIMIT
,      LATEST_OPENED_PERIOD_NAME
,      LATEST_ENCUMBRANCE_YEAR
,      RET_EARN_CODE_COMBINATION_ID
,      CUM_TRANS_CODE_COMBINATION_ID
,      RES_ENCUMB_CODE_COMBINATION_ID
,      NET_INCOME_CODE_COMBINATION_ID
,      ROUNDING_CODE_COMBINATION_ID
,      TRANSACTION_CALENDAR_ID
,      DAILY_TRANSLATION_RATE_TYPE
,      EARLIEST_UNTRANS_PERIOD_NAME
,      DESCRIPTION
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
,      CONTEXT
,      GLOBAL_ATTRIBUTE_CATEGORY
,      GLOBAL_ATTRIBUTE1
,      GLOBAL_ATTRIBUTE2
,      GLOBAL_ATTRIBUTE3
,      GLOBAL_ATTRIBUTE4
,      GLOBAL_ATTRIBUTE5
,      GLOBAL_ATTRIBUTE6
,      GLOBAL_ATTRIBUTE7
,      GLOBAL_ATTRIBUTE8
,      GLOBAL_ATTRIBUTE9
,      GLOBAL_ATTRIBUTE10
,      TRACK_ENTERED_FUNC_CURR_FLAG
,      ENABLE_SECONDARY_TRACK_FLAG
,      ENABLE_REVAL_SS_TRACK_FLAG
,      BAL_SEG_COLUMN_NAME
FROM GL.GL_SETS_OF_BOOKS_11I;

Dependencies

[top of page]

GL.GL_SETS_OF_BOOKS_11I does not reference any database object

GL.GL_SETS_OF_BOOKS_11I is referenced by following:

GL: GL_SETS_OF_BOOKS_11I#