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

VIEW: APPS.FA_BOOKS_BOOK_CONTROLS_V

Object Details
Object Name: FA_BOOKS_BOOK_CONTROLS_V
Object Type: VIEW
Owner: APPS
FND Design Data: ViewOFA.FA_BOOKS_BOOK_CONTROLS_V
Subobject Name:
Status: VALID

[View Source]

Columns
Name Datatype Length Mandatory Comments
BOOK_CLASS VARCHAR2 (15) Yes
TRANSACTION_HEADER_ID_IN NUMBER (15) Yes
TRANSACTION_HEADER_ID_OUT NUMBER (15)
BOOK_TYPE_CODE VARCHAR2 (15) Yes
ASSET_ID NUMBER (15) Yes
DATE_INEFFECTIVE DATE

COST NUMBER
Yes
ORIGINAL_COST NUMBER
Yes
CEILING_NAME VARCHAR2 (30)
SALVAGE_VALUE NUMBER
Yes
REVAL_CEILING NUMBER

ITC_BASIS NUMBER

ITC_AMOUNT_ID NUMBER (15)
DATE_PLACED_IN_SERVICE DATE
Yes
DEPRECIATE_FLAG VARCHAR2 (3) Yes
PRORATE_CONVENTION_CODE VARCHAR2 (10) Yes
PRORATE_DATE DATE
Yes
DEPRN_METHOD_CODE VARCHAR2 (12) Yes
LIFE_IN_MONTHS NUMBER (4)
BASIC_RATE NUMBER

ADJUSTED_RATE NUMBER

BONUS_RULE VARCHAR2 (30)
UNIT_OF_MEASURE VARCHAR2 (25)
PRODUCTION_CAPACITY NUMBER

DISABLED_FLAG VARCHAR2 (1)
CASH_GENERATING_UNIT_ID NUMBER (15)
Query Text

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


SELECT BOOK_CLASS
,      TRANSACTION_HEADER_ID_IN
,      TRANSACTION_HEADER_ID_OUT
,      BOOK_TYPE_CODE
,      ASSET_ID
,      DATE_INEFFECTIVE
,      COST
,      ORIGINAL_COST
,      CEILING_NAME
,      SALVAGE_VALUE
,      REVAL_CEILING
,      ITC_BASIS
,      ITC_AMOUNT_ID
,      DATE_PLACED_IN_SERVICE
,      DEPRECIATE_FLAG
,      PRORATE_CONVENTION_CODE
,      PRORATE_DATE
,      DEPRN_METHOD_CODE
,      LIFE_IN_MONTHS
,      BASIC_RATE
,      ADJUSTED_RATE
,      BONUS_RULE
,      UNIT_OF_MEASURE
,      PRODUCTION_CAPACITY
,      DISABLED_FLAG
,      CASH_GENERATING_UNIT_ID
FROM APPS.FA_BOOKS_BOOK_CONTROLS_V;

Dependencies

[top of page]

APPS.FA_BOOKS_BOOK_CONTROLS_V references the following:

SchemaAPPS
SynonymFA_BOOKS
SynonymFA_BOOK_CONTROLS

APPS.FA_BOOKS_BOOK_CONTROLS_V is not referenced by any database object