Skip to content

DBA Data[Home] [Help] [Dependency Information]

VIEW: APPS.OKX_SET_OF_BOOKS_V

Object Details
Object Name: OKX_SET_OF_BOOKS_V
Object Type: VIEW
Owner: APPS
FND Design Data: ViewOKX.OKX_SET_OF_BOOKS_V
Subobject Name:
Status: VALID

View Type

A public view which may be useful for custom reporting or other data
requirements.


Displays information about the sets of books (Accounting Entities) you define in your Oracle General Ledger application.


[View Source]

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
CURRENCY_CODE VARCHAR2 (15) Yes Currency
MRC_SOB_TYPE_CODE VARCHAR2 (1)
MRC set of books type (Parent, Reporting, None)
DESCRIPTION VARCHAR2 (240)
Accounting books description
Query Text

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


SELECT SET_OF_BOOKS_ID
,      NAME
,      SHORT_NAME
,      CURRENCY_CODE
,      MRC_SOB_TYPE_CODE
,      DESCRIPTION
FROM APPS.OKX_SET_OF_BOOKS_V;

Dependencies

[top of page]

APPS.OKX_SET_OF_BOOKS_V references the following:

SchemaAPPS
ViewGL_SETS_OF_BOOKS
APPS.OKX_SET_OF_BOOKS_V is referenced by following:

SchemaAPPS
Package BodyOKC_CURRENCY_API - show dependent code
Package BodyOKC_EURO_CONV_PUB - show dependent code
Package BodyOKC_UTIL - show dependent code