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: IGI.IGI_IAC_ASSET_REP_ITF#

Object Details

Object Name:	IGI_IAC_ASSET_REP_ITF#
Object Type:	VIEW
Owner:	IGI
Subobject Name:
Status:	VALID

[View Source]

Columns

Name	Datatype	Length	Mandatory
REQUEST_ID	NUMBER
COMPANY_NAME	VARCHAR2	(30)
BOOK_TYPE_CODE	VARCHAR2	(15)
PERIOD	VARCHAR2	(30)
FISCAL_YEAR_NAME	VARCHAR2	(30)
MAJOR_CATEGORY	VARCHAR2	(25)
MINOR_CATEGORY	VARCHAR2	(25)
COST_CENTER	VARCHAR2	(25)
ASSET_NUMBER	VARCHAR2	(15)
ASSET_DESCRIPTION	VARCHAR2	(80)
REVAL_COST	NUMBER
REVAL_RESERVE	NUMBER
GENERAL_FUND	NUMBER
OPER_ACCT	NUMBER
DEPRN_RESV	NUMBER
BACKLOG	NUMBER
DEPRN_PERIOD	NUMBER
YTD_DEPRN	NUMBER
DEPRN_BACKLOG	NUMBER
DEPRN_TOTAL	NUMBER
REVAL_RESV_COST	NUMBER
REVAL_RESV_BLOG	NUMBER
REVAL_RESV_GEN_FUND	NUMBER
REVAL_RESV_NET	NUMBER
OPER_EXP	NUMBER
OPER_EXP_BACKLOG	NUMBER
OPER_EXP_NET	NUMBER
FUNCTIONAL_CURRENCY_CODE	VARCHAR2	(15)
ORGANISATION_NAME	VARCHAR2	(30)
PARENT_NO	VARCHAR2	(15)
CURR_REVAL_FACTOR	NUMBER	(15)
CUM_REVAL_FACTOR	NUMBER	(15)
ASSET_TAG	VARCHAR2	(30)
BALANCING_SEGMENT	VARCHAR2	(30)
SERIAL_NO	VARCHAR2	(35)
DPIS	DATE
LIFE_MONTHS	NUMBER	(15)
STL_RATE	NUMBER	(15)
DEPRECIATION_METHOD	VARCHAR2	(30)
CONC_ASSET_KEY	VARCHAR2	(240)
CONC_LOCATION	VARCHAR2	(240)
COST_ACCT	VARCHAR2	(30)
IAC_REVAL_RESV_ACCT	NUMBER
DEPRN_RES_ACCT	NUMBER
DEPRN_BACKLOG_ACCT	NUMBER
GEN_FUND_ACCT	NUMBER
DEPRN_EXP_ACCT	NUMBER
OPER_EXP_ACCT	NUMBER
CONCAT_CATEGORY	VARCHAR2	(600)
CREATED_BY	NUMBER	(15)	Yes
CREATION_DATE	DATE		Yes
LAST_UPDATE_LOGIN	NUMBER
LAST_UPDATED_BY	NUMBER	(15)	Yes
LAST_UPDATE_DATE	DATE		Yes

Query Text

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


SELECT REQUEST_ID
,      COMPANY_NAME
,      BOOK_TYPE_CODE
,      PERIOD
,      FISCAL_YEAR_NAME
,      MAJOR_CATEGORY
,      MINOR_CATEGORY
,      COST_CENTER
,      ASSET_NUMBER
,      ASSET_DESCRIPTION
,      REVAL_COST
,      REVAL_RESERVE
,      GENERAL_FUND
,      OPER_ACCT
,      DEPRN_RESV
,      BACKLOG
,      DEPRN_PERIOD
,      YTD_DEPRN
,      DEPRN_BACKLOG
,      DEPRN_TOTAL
,      REVAL_RESV_COST
,      REVAL_RESV_BLOG
,      REVAL_RESV_GEN_FUND
,      REVAL_RESV_NET
,      OPER_EXP
,      OPER_EXP_BACKLOG
,      OPER_EXP_NET
,      FUNCTIONAL_CURRENCY_CODE
,      ORGANISATION_NAME
,      PARENT_NO
,      CURR_REVAL_FACTOR
,      CUM_REVAL_FACTOR
,      ASSET_TAG
,      BALANCING_SEGMENT
,      SERIAL_NO
,      DPIS
,      LIFE_MONTHS
,      STL_RATE
,      DEPRECIATION_METHOD
,      CONC_ASSET_KEY
,      CONC_LOCATION
,      COST_ACCT
,      IAC_REVAL_RESV_ACCT
,      DEPRN_RES_ACCT
,      DEPRN_BACKLOG_ACCT
,      GEN_FUND_ACCT
,      DEPRN_EXP_ACCT
,      OPER_EXP_ACCT
,      CONCAT_CATEGORY
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATE_LOGIN
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
FROM IGI.IGI_IAC_ASSET_REP_ITF#;

Dependencies

[top of page]

IGI.IGI_IAC_ASSET_REP_ITF# references the following:

IGI: IGI_IAC_ASSET_REP_ITF

IGI.IGI_IAC_ASSET_REP_ITF# is referenced by following:

APPS: IGI_IAC_ASSET_REP_ITF