[Home] [Help] [Dependency Information]

VIEW: APPS.GL_SETS_OF_BOOKS_V

Object Details

Object Name:	GL_SETS_OF_BOOKS_V
Object Type:	VIEW
Owner:	APPS
FND Design Data:	SQLGL.GL_SETS_OF_BOOKS_V
Subobject Name:
Status:	VALID

View Type

A supplementary view used to simplify forms coding.

Warning: Oracle does not recommend you query or alter datausing this view. It may change dramatically in subsequent minor or major
releases.

[View Source]

Columns

Query Text

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

SELECT ROW_ID
,      SET_OF_BOOKS_ID
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CURRENCY_CODE
,      CHART_OF_ACCOUNTS_ID
,      CHART_OF_ACCOUNTS_NAME
,      NAME
,      PERIOD_SET_NAME
,      SUSPENSE_ALLOWED_FLAG
,      ALLOW_POSTING_WARNING_FLAG
,      ACCOUNTED_PERIOD_TYPE
,      USER_PERIOD_TYPE
,      SHORT_NAME
,      REQUIRE_BUDGET_JOURNALS_FLAG
,      ENABLE_BUDGETARY_CONTROL_FLAG
,      ALLOW_INTERCOMPANY_POST_FLAG
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_LOGIN
,      LATEST_ENCUMBRANCE_YEAR
,      EARLIEST_UNTRANS_PERIOD_NAME
,      CUM_TRANS_CODE_COMBINATION_ID
,      FUTURE_ENTERABLE_PERIODS_LIMIT
,      LATEST_OPENED_PERIOD_NAME
,      RET_EARN_CODE_COMBINATION_ID
,      RES_ENCUMB_CODE_COMBINATION_ID
,      SUSPENSE_CCID
,      NET_INCOME_CODE_COMBINATION_ID
,      TRANSACTION_CALENDAR_ID
,      ENABLE_AVGBAL_FLAG
,      CONSOLIDATION_SOB_FLAG
,      TRANSLATE_EOD_FLAG
,      TRANSLATE_QATD_FLAG
,      TRANSLATE_YATD_FLAG
,      DAILY_TRANSLATION_RATE_TYPE
,      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
,      ENABLE_AUTOMATIC_TAX_FLAG
,      ENABLE_JE_APPROVAL_FLAG
,      TRANSACTION_CALENDAR_NAME
,      BALANCING_SEGMENT
,      DAILY_USER_TRANSLATION_TYPE
,      MRC_SOB_TYPE_CODE
,      TRACK_ROUNDING_IMBALANCE_FLAG
,      ROUNDING_CCID
FROM APPS.GL_SETS_OF_BOOKS_V;

Dependencies

[top of page]

APPS

FND_ID_FLEX_STRUCTURES_TL

GL_DAILY_CONVERSION_TYPES

GL_LEDGERS

GL_NET_INCOME_ACCOUNTS

GL_PERIOD_TYPES

GL_SUSPENSE_ACCOUNTS

GL_TRANSACTION_CALENDAR

APPS

CNSYSP_SYSTEM_PARAMETERS_PKG - show dependent code

JA_JAINAPCR_XMLP_PKG - show dependent code