Skip to content

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

TABLE: IGI.IGI_IMP_IAC_ITF

Object Details
Object Name: IGI_IMP_IAC_ITF
Object Type: TABLE
Owner: IGI
Subobject Name:
Status: VALID

***** Warning: Oracle Internal Use Only *****

Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.

Storage Details
Tablespace: TablespaceAPPS_TS_INTERFACE
PCT Free: 10
PCT Used:
Columns
Name Datatype Length Mandatory Comments
BOOK_TYPE_CODE VARCHAR2 (15)
Book Type identifier
REQUEST_ID NUMBER (15)
Request Id
SET_OF_BOOKS_ID NUMBER (15)
Set of Books identifier
ASSET_ID NUMBER (15)
Asset Id
CATEGORY_ID NUMBER (15)
Category ID
DISTRIBUTION_ID NUMBER (15)
Distribution Id
FUNCTIONAL_CURRENCY_CODE VARCHAR2 (15)
Functional Currency
FISCAL_YEAR_NAME VARCHAR2 (15)
Fiscal Year
PERIOD VARCHAR2 (15)
Period Name
COST_CENTER VARCHAR2 (30)
Cost Center
ASSET_NUMBER VARCHAR2 (15)
Asset Number
ASSET_DESCRIPTION VARCHAR2 (80)
Asset Description
MAJOR_CATEGORY VARCHAR2 (30)
Major Category
MINOR_CATEGORY VARCHAR2 (30)
Minor Category
CONCAT_CATEGORY VARCHAR2 (80)
Category
REVAL_COST NUMBER

Revaluation Reserve Cost
NET_REVAL_RESERVE NUMBER

Net Revaluation Reserve
REVAL_RES_BLOG NUMBER

Revaluation Reserve Backlog
REVAL_YTD_DEPRN NUMBER

Depreciation Year to Date
REVAL_DEPRN_RESERVE NUMBER

Depreciation Reserve
OPER_ACCT NUMBER

Operating Account
OPER_EXP_BACKLOG NUMBER

Opearting Expense Backlog
GENERAL_FUND NUMBER

General Fund
PARENT_NO NUMBER (15)
Parent
CURR_REVAL_FACTOR NUMBER

Current Revaluation Factor
CUMM_REVAL_FACTOR NUMBER

Cumulative Revlaution factor
ASSET_TAG VARCHAR2 (15)
Asset Tag
BALANCING_SEGMENT VARCHAR2 (30)
Balancing Segment
SERIAL_NO VARCHAR2 (35)
Serial Number
DPIS DATE

Date Placed in service
LIFE_MONTHS NUMBER

Asset Life
STL_RATE NUMBER

Rate
DEPRECIATION_METHOD VARCHAR2 (30)
Depreciation Method
CONC_ASSET_KEY VARCHAR2 (80)
Asset Key
CONC_LOCATION VARCHAR2 (80)
Location
COST_ACCT VARCHAR2 (25)
Cost Account
IAC_REVAL_RESV_ACCT VARCHAR2 (25)
Revaluation Reserve Account
DEPRN_RES_ACCT VARCHAR2 (25)
Depreciation Reserve Account
DEPRN_BACKLOG_ACCT VARCHAR2 (25)
Backlog Account
GEN_FUND_ACCT VARCHAR2 (25)
General Fund Account
DEPRN_EXP_ACCT VARCHAR2 (25)
Expense Account
OPER_EXP_ACCT VARCHAR2 (25)
Operating Expense Account
HIST_COST NUMBER

Historic Cost
HIST_YTD_DEPRN NUMBER

Historic Year to Date Depreciation
HIST_ACC_DEPRN NUMBER

Historic Accumlated Depreciation
ORGANIZATION_NAME VARCHAR2 (80)
Organization Name
CREATED_BY NUMBER (15)
Standard who column - user who created this row (foreign key to FND_USER.USER_ID).
CREATION_DATE DATE

Standard who column - date when this row was created.
LAST_UPDATE_LOGIN NUMBER (15)
Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID)
LAST_UPDATED_BY NUMBER (15)
Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID).
LAST_UPDATE_DATE DATE

Standard Who column - date when a user last updated this row.
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 does not reference any database object

IGI.IGI_IMP_IAC_ITF is referenced by following:

SchemaIGI
ViewIGI_IMP_IAC_ITF#