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

VIEW: APPS.OKX_ASST_BK_CONTROLS_V

Object Details
Object Name: OKX_ASST_BK_CONTROLS_V
Object Type: VIEW
Owner: APPS
FND Design Data: ViewOKX.OKX_ASST_BK_CONTROLS_V
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.

View Type

Internal

[View Source]

Columns
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
Query Text

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;

Dependencies

[top of page]

APPS.OKX_ASST_BK_CONTROLS_V references the following:

SchemaAPPS
SynonymFA_BOOK_CONTROLS
APPS.OKX_ASST_BK_CONTROLS_V is referenced by following:

SchemaAPPS
Package BodyOKL_ACTIVATE_ASSET_PVT - show dependent code
Package BodyOKL_AMH_PVT - show dependent code
Package BodyOKL_ASD_PVT - show dependent code
Package BodyOKL_LIKE_KIND_EXCHANGE_PVT - show dependent code
Package BodyOKL_OVD_PVT - show dependent code
Package BodyOKL_SPLIT_ASSET_PVT - show dependent code
Package BodyOKL_TAL_PVT - show dependent code