[Home] [Help] [Dependency Information]
Object Name: | IGI_IMP_IAC_ITF |
---|---|
Object Type: | TABLE |
Owner: | IGI |
Subobject Name: | |
Status: | VALID |
Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.
Tablespace: | APPS_TS_INTERFACE |
---|---|
PCT Free: | 10 |
PCT Used: |
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. |
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;
IGI.IGI_IMP_IAC_ITF does not reference any database object
IGI.IGI_IMP_IAC_ITF is referenced by following:
|
|
|