[Home] [Help] [Dependency Information]
Object Name: | OKX_ASST_BK_CONTROLS_V |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | OKX.OKX_ASST_BK_CONTROLS_V |
Subobject Name: | |
Status: | VALID |
Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.
Internal
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
ID1 | VARCHAR2 | (15) | Yes | Primary key column. Book name |
ID2 | CHAR | (1) | Primary key column | |
NAME | VARCHAR2 | (15) | Yes | Book name |
DESCRIPTION | VARCHAR2 | (30) | Yes | Book description |
BOOK_TYPE_CODE | VARCHAR2 | (15) | Yes | Book name |
SET_OF_BOOKS_ID | NUMBER | (15) | Yes | Set of books identification number for GL sets of books |
START_DATE_ACTIVE | DATE | Yes | Effective from date | |
END_DATE_ACTIVE | DATE | Effective to date | ||
STATUS | VARCHAR2 | (1) | Indicates whether the record is active or inactive | |
PRIMARY_UOM_CODE | VARCHAR2 | (0) | Primary unit of measure code | |
LAST_DEPRN_RUN_DATE | DATE | Yes | Date of last depreciation | |
AMORTIZE_FLAG | VARCHAR2 | (3) | Yes | Indicates whether or not to allow amortized changes |
FULLY_RESERVED_FLAG | VARCHAR2 | (3) | Yes | Not used |
DEPRN_CALENDAR | VARCHAR2 | (15) | Yes | Name of depreciation calendar |
BOOK_CLASS | VARCHAR2 | (15) | Yes | Indicates whether the book is a corporate tax or budget book |
MASS_COPY_SOURCE_BOOK | VARCHAR2 | (15) | Associated coprporate book to mass copy from | |
ORG_ID | NUMBER | (15) | Identifies operating unit | |
ALLOW_MASS_CHANGES | VARCHAR2 | (3) | Yes | Indicates whether or not to allow mass changes |
PRORATE_CALENDAR | VARCHAR2 | (15) | Yes | Name of prorate calendar |
COPY_RETIREMENTS_FLAG | VARCHAR2 | (3) | Yes | Indicates whether or not to copy retirements in mass copy |
COPY_ADJUSTMENTS_FLAG | VARCHAR2 | (3) | Yes | Indicates whether or not to copy adjustments in mass copy |
ALLOW_MASS_COPY | VARCHAR2 | (3) | Yes | Indicates whether or not to allow mass copy |
ALLOW_PURGE_FLAG | VARCHAR2 | (3) | Indicates whether or not to allow purge | |
ALLOW_REVAL_FLAG | VARCHAR2 | (3) | Yes | Indicates whether or not to allow revaluation |
AMORTIZE_REVAL_RESERVE_FLAG | VARCHAR2 | (3) | Indicates whetehr or not to amortize revaluation reserve | |
COPY_SALVAGE_VALUE_FLAG | VARCHAR2 | (3) | Yes | Indicates whether or not to mass copy salvage value |
LAST_MASS_COPY_PERIOD_COUNTER | NUMBER | (15) | Last corporate period mass copied into this tax book | |
LAST_PERIOD_COUNTER | NUMBER | (15) | Yes | Last period depreciated in this book |
IMMEDIATE_COPY_FLAG | VARCHAR2 | (3) | Indicates whether to copy immediately from corporate book to tax book | |
COPY_ADDITIONS_FLAG | VARCHAR2 | (3) | Yes | Indicates whether or not to copy additions in a mass copy |
USE_PERCENT_SALVAGE_VALUE_FLAG | VARCHAR2 | (3) | Not used |
Cut, paste (and edit) the following text to query this object:
SELECT ID1
, ID2
, NAME
, DESCRIPTION
, BOOK_TYPE_CODE
, SET_OF_BOOKS_ID
, START_DATE_ACTIVE
, END_DATE_ACTIVE
, STATUS
, PRIMARY_UOM_CODE
, LAST_DEPRN_RUN_DATE
, AMORTIZE_FLAG
, FULLY_RESERVED_FLAG
, DEPRN_CALENDAR
, BOOK_CLASS
, MASS_COPY_SOURCE_BOOK
, ORG_ID
, ALLOW_MASS_CHANGES
, PRORATE_CALENDAR
, COPY_RETIREMENTS_FLAG
, COPY_ADJUSTMENTS_FLAG
, ALLOW_MASS_COPY
, ALLOW_PURGE_FLAG
, ALLOW_REVAL_FLAG
, AMORTIZE_REVAL_RESERVE_FLAG
, COPY_SALVAGE_VALUE_FLAG
, LAST_MASS_COPY_PERIOD_COUNTER
, LAST_PERIOD_COUNTER
, IMMEDIATE_COPY_FLAG
, COPY_ADDITIONS_FLAG
, USE_PERCENT_SALVAGE_VALUE_FLAG
FROM APPS.OKX_ASST_BK_CONTROLS_V;
|
|
|