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: JG.JG_ZZ_FA_REG_ITF#

Object Details

Object Name:	JG_ZZ_FA_REG_ITF#
Object Type:	VIEW
Owner:	JG
Subobject Name:
Status:	VALID

[View Source]

Columns

Name	Datatype	Length	Mandatory
REQUEST_ID	NUMBER		Yes
ORGANIZATION_NAME	VARCHAR2	(60)	Yes
FUNCTIONAL_CURRENCY_CODE	VARCHAR2	(15)	Yes
LAST_UPDATE_DATE	DATE		Yes
LAST_UPDATED_BY	NUMBER		Yes
LAST_UPDATE_LOGIN	NUMBER
CREATION_DATE	DATE		Yes
CREATED_BY	NUMBER		Yes
MAJOR_CATEGORY	VARCHAR2	(30)	Yes
MINOR_CATEGORY	VARCHAR2	(30)
DEPRN_RATE	NUMBER
STARTING_DEPRN_YEAR	VARCHAR2	(4)
ASSET_HEADING	VARCHAR2	(15)
ASSET_NUMBER	VARCHAR2	(15)	Yes
DESCRIPTION	VARCHAR2	(80)
PARENT_ASSET_ID	NUMBER
PARENT_ASSET_NUMBER	VARCHAR2	(15)
ASSET_COST_ORIG	NUMBER
BONUS_RATE	NUMBER
INVOICE_NUMBER	VARCHAR2	(50)
SUPPLIER_NAME	VARCHAR2	(360)
COST_ACCOUNT	VARCHAR2	(25)
EXPENSE_ACCOUNT	VARCHAR2	(25)
RESERVE_ACCOUNT	VARCHAR2	(25)
BONUS_DEPRN_ACCOUNT	VARCHAR2	(25)
BONUS_RESERVE_ACCOUNT	VARCHAR2	(25)
ASSET_COST_INITIAL	NUMBER
ASSET_COST_INCREASE	NUMBER
ASSET_COST_DECREASE	NUMBER
ASSET_COST_FINAL	NUMBER
REVALUATION_INITIAL	NUMBER
REVALUATION_INCREASE	NUMBER
REVALUATION_DECREASE	NUMBER
REVALUATION_FINAL	NUMBER
DEPRN_RESERVE_INITIAL	NUMBER
DEPRN_RESERVE_INCREASE	NUMBER
DEPRN_RESERVE_DECREASE	NUMBER
DEPRN_RESERVE_FINAL	NUMBER
BONUS_RESERVE_INITIAL	NUMBER
BONUS_RESERVE_INCREASE	NUMBER
BONUS_RESERVE_DECREASE	NUMBER
BONUS_RESERVE_FINAL	NUMBER
NET_BOOK_VALUE_INITIAL	NUMBER
NET_BOOK_VALUE_INCREASE	NUMBER
NET_BOOK_VALUE_DECREASE	NUMBER
NET_BOOK_VALUE_FINAL	NUMBER
TRANSACTION_DATE	DATE
TRANSACTION_NUMBER	NUMBER
TRANSACTION_CODE	VARCHAR2	(20)
TRANSACTION_AMOUNT	NUMBER
SALES_AMOUNT	NUMBER
COST_RETIRED	NUMBER
DATE_RETIRED	DATE
DEPRN_RESERVE	NUMBER
BONUS_RESERVE	NUMBER
NET_BOOK_VALUE	NUMBER
GAIN_LOSS	NUMBER
HEADER	VARCHAR2	(110)
DATE_PLACED_IN_SERVICE	DATE
INITIAL_HEADING	VARCHAR2	(15)
VARIATION_HEADING	VARCHAR2	(15)
FINAL_HEADING	VARCHAR2	(132)
ASSET_VARIATION	NUMBER
REVAL_VARIATION	NUMBER
DEPRN_VARIATION	NUMBER
BONUS_VARIATION	NUMBER
NETBO_VARIATION	NUMBER
REVALUATION_TOTAL	NUMBER
DEPRECIATION_METHOD	VARCHAR2	(12)
LIFE_IN_MONTHS	NUMBER
LIFE_IN_YEARS	NUMBER
PRORATE_CONVENTION	VARCHAR2	(10)
TAG_NUMBER	VARCHAR2	(15)
SERIAL_NUMBER	VARCHAR2	(35)
ASSET_KEY_FLEXFIELD	VARCHAR2	(35)
YTD_DEPRN	NUMBER	(15)

Query Text

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


SELECT REQUEST_ID
,      ORGANIZATION_NAME
,      FUNCTIONAL_CURRENCY_CODE
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      CREATION_DATE
,      CREATED_BY
,      MAJOR_CATEGORY
,      MINOR_CATEGORY
,      DEPRN_RATE
,      STARTING_DEPRN_YEAR
,      ASSET_HEADING
,      ASSET_NUMBER
,      DESCRIPTION
,      PARENT_ASSET_ID
,      PARENT_ASSET_NUMBER
,      ASSET_COST_ORIG
,      BONUS_RATE
,      INVOICE_NUMBER
,      SUPPLIER_NAME
,      COST_ACCOUNT
,      EXPENSE_ACCOUNT
,      RESERVE_ACCOUNT
,      BONUS_DEPRN_ACCOUNT
,      BONUS_RESERVE_ACCOUNT
,      ASSET_COST_INITIAL
,      ASSET_COST_INCREASE
,      ASSET_COST_DECREASE
,      ASSET_COST_FINAL
,      REVALUATION_INITIAL
,      REVALUATION_INCREASE
,      REVALUATION_DECREASE
,      REVALUATION_FINAL
,      DEPRN_RESERVE_INITIAL
,      DEPRN_RESERVE_INCREASE
,      DEPRN_RESERVE_DECREASE
,      DEPRN_RESERVE_FINAL
,      BONUS_RESERVE_INITIAL
,      BONUS_RESERVE_INCREASE
,      BONUS_RESERVE_DECREASE
,      BONUS_RESERVE_FINAL
,      NET_BOOK_VALUE_INITIAL
,      NET_BOOK_VALUE_INCREASE
,      NET_BOOK_VALUE_DECREASE
,      NET_BOOK_VALUE_FINAL
,      TRANSACTION_DATE
,      TRANSACTION_NUMBER
,      TRANSACTION_CODE
,      TRANSACTION_AMOUNT
,      SALES_AMOUNT
,      COST_RETIRED
,      DATE_RETIRED
,      DEPRN_RESERVE
,      BONUS_RESERVE
,      NET_BOOK_VALUE
,      GAIN_LOSS
,      HEADER
,      DATE_PLACED_IN_SERVICE
,      INITIAL_HEADING
,      VARIATION_HEADING
,      FINAL_HEADING
,      ASSET_VARIATION
,      REVAL_VARIATION
,      DEPRN_VARIATION
,      BONUS_VARIATION
,      NETBO_VARIATION
,      REVALUATION_TOTAL
,      DEPRECIATION_METHOD
,      LIFE_IN_MONTHS
,      LIFE_IN_YEARS
,      PRORATE_CONVENTION
,      TAG_NUMBER
,      SERIAL_NUMBER
,      ASSET_KEY_FLEXFIELD
,      YTD_DEPRN
FROM JG.JG_ZZ_FA_REG_ITF#;

Dependencies

[top of page]

JG.JG_ZZ_FA_REG_ITF# references the following:

JG: JG_ZZ_FA_REG_ITF

JG.JG_ZZ_FA_REG_ITF# is referenced by following:

APPS: JG_ZZ_FA_REG_ITF