[Home] [Help] [Dependency Information]
Object Name: | OKX_SET_OF_BOOKS_V |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | OKX.OKX_SET_OF_BOOKS_V |
Subobject Name: | |
Status: | VALID |
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.
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 |
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;
|
|
|