eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

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:	OFA.FA_BOOKS_BOOK_CONTROLS_V
Subobject Name:
Status:	VALID

View Type

A supplementary view used to simplify forms coding.

Warning: Oracle does not recommend you query or alter datausing this view. It may change dramatically in subsequent minor or major
releases.

[View Source]

Columns

Name	Datatype	Length
BOOK_CLASS	VARCHAR2	(15)
TRANSACTION_HEADER_ID_IN	NUMBER	(15)
TRANSACTION_HEADER_ID_OUT	NUMBER	(15)
BOOK_TYPE_CODE	VARCHAR2	(30)
ASSET_ID	NUMBER	(15)
DATE_INEFFECTIVE	DATE
COST	NUMBER
ORIGINAL_COST	NUMBER
CEILING_NAME	VARCHAR2	(30)
SALVAGE_VALUE	NUMBER
REVAL_CEILING	NUMBER
ITC_BASIS	NUMBER
ITC_AMOUNT_ID	NUMBER	(15)
DATE_PLACED_IN_SERVICE	DATE
DEPRECIATE_FLAG	VARCHAR2	(3)
PRORATE_CONVENTION_CODE	VARCHAR2	(10)
PRORATE_DATE	DATE
DEPRN_METHOD_CODE	VARCHAR2	(12)
LIFE_IN_MONTHS	NUMBER
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)
SOB_ID	NUMBER	(15)
LEDGER_NAME	VARCHAR2	(30)
CURRENCY_CODE	VARCHAR2	(15)
TYPE	VARCHAR2	(9)

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
,      SOB_ID
,      LEDGER_NAME
,      CURRENCY_CODE
,      TYPE
FROM APPS.FA_BOOKS_BOOK_CONTROLS_V;

Dependencies

[top of page]

APPS.FA_BOOKS_BOOK_CONTROLS_V references the following:

APPS: FA_BOOKS; FA_BOOK_CONTROLS; FA_MC_BOOKS; GL_LEDGERS

APPS.FA_BOOKS_BOOK_CONTROLS_V is not referenced by any database object