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_IMP_IAC_ITF#

Object Details

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

[View Source]

Columns

Name	Datatype	Length
BOOK_TYPE_CODE	VARCHAR2	(15)
REQUEST_ID	NUMBER	(15)
SET_OF_BOOKS_ID	NUMBER	(15)
ASSET_ID	NUMBER	(15)
CATEGORY_ID	NUMBER	(15)
DISTRIBUTION_ID	NUMBER	(15)
FUNCTIONAL_CURRENCY_CODE	VARCHAR2	(15)
FISCAL_YEAR_NAME	VARCHAR2	(15)
PERIOD	VARCHAR2	(15)
COST_CENTER	VARCHAR2	(30)
ASSET_NUMBER	VARCHAR2	(15)
ASSET_DESCRIPTION	VARCHAR2	(80)
MAJOR_CATEGORY	VARCHAR2	(30)
MINOR_CATEGORY	VARCHAR2	(30)
CONCAT_CATEGORY	VARCHAR2	(80)
REVAL_COST	NUMBER
NET_REVAL_RESERVE	NUMBER
REVAL_RES_BLOG	NUMBER
REVAL_YTD_DEPRN	NUMBER
REVAL_DEPRN_RESERVE	NUMBER
OPER_ACCT	NUMBER
OPER_EXP_BACKLOG	NUMBER
GENERAL_FUND	NUMBER
PARENT_NO	NUMBER	(15)
CURR_REVAL_FACTOR	NUMBER
CUMM_REVAL_FACTOR	NUMBER
ASSET_TAG	VARCHAR2	(15)
BALANCING_SEGMENT	VARCHAR2	(30)
SERIAL_NO	VARCHAR2	(35)
DPIS	DATE
LIFE_MONTHS	NUMBER
STL_RATE	NUMBER
DEPRECIATION_METHOD	VARCHAR2	(30)
CONC_ASSET_KEY	VARCHAR2	(80)
CONC_LOCATION	VARCHAR2	(80)
COST_ACCT	VARCHAR2	(25)
IAC_REVAL_RESV_ACCT	VARCHAR2	(25)
DEPRN_RES_ACCT	VARCHAR2	(25)
DEPRN_BACKLOG_ACCT	VARCHAR2	(25)
GEN_FUND_ACCT	VARCHAR2	(25)
DEPRN_EXP_ACCT	VARCHAR2	(25)
OPER_EXP_ACCT	VARCHAR2	(25)
HIST_COST	NUMBER
HIST_YTD_DEPRN	NUMBER
HIST_ACC_DEPRN	NUMBER
ORGANIZATION_NAME	VARCHAR2	(80)
CREATED_BY	NUMBER	(15)
CREATION_DATE	DATE
LAST_UPDATE_LOGIN	NUMBER	(15)
LAST_UPDATED_BY	NUMBER	(15)
LAST_UPDATE_DATE	DATE

Query Text

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


SELECT BOOK_TYPE_CODE
,      REQUEST_ID
,      SET_OF_BOOKS_ID
,      ASSET_ID
,      CATEGORY_ID
,      DISTRIBUTION_ID
,      FUNCTIONAL_CURRENCY_CODE
,      FISCAL_YEAR_NAME
,      PERIOD
,      COST_CENTER
,      ASSET_NUMBER
,      ASSET_DESCRIPTION
,      MAJOR_CATEGORY
,      MINOR_CATEGORY
,      CONCAT_CATEGORY
,      REVAL_COST
,      NET_REVAL_RESERVE
,      REVAL_RES_BLOG
,      REVAL_YTD_DEPRN
,      REVAL_DEPRN_RESERVE
,      OPER_ACCT
,      OPER_EXP_BACKLOG
,      GENERAL_FUND
,      PARENT_NO
,      CURR_REVAL_FACTOR
,      CUMM_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
,      HIST_COST
,      HIST_YTD_DEPRN
,      HIST_ACC_DEPRN
,      ORGANIZATION_NAME
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATE_LOGIN
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
FROM IGI.IGI_IMP_IAC_ITF#;

Dependencies

[top of page]

IGI.IGI_IMP_IAC_ITF# references the following:

IGI: IGI_IMP_IAC_ITF

IGI.IGI_IMP_IAC_ITF# is referenced by following:

APPS: IGI_IMP_IAC_ITF