[Home] [Help] [Dependency Information]
Object Name: | IGI_IAC_ASSET_REP_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 |
---|---|---|---|---|
REQUEST_ID | NUMBER | Concurrent Program who column - concurrent request id of the program that last updated this row (foreign key to FND_CONCURRENT_REQUESTS.REQUEST_ID). | ||
COMPANY_NAME | VARCHAR2 | (30) | Company Name | |
BOOK_TYPE_CODE | VARCHAR2 | (15) | Book Code | |
PERIOD | VARCHAR2 | (30) | Period | |
FISCAL_YEAR_NAME | VARCHAR2 | (30) | fiscal year name | |
MAJOR_CATEGORY | VARCHAR2 | (25) | ||
MINOR_CATEGORY | VARCHAR2 | (25) | ||
COST_CENTER | VARCHAR2 | (25) | ||
ASSET_NUMBER | VARCHAR2 | (15) | Asset Number Value | |
ASSET_DESCRIPTION | VARCHAR2 | (80) | Asset Description | |
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) | Parent no. | |
CURR_REVAL_FACTOR | NUMBER | (15) | Current Revaluation Factor | |
CUM_REVAL_FACTOR | NUMBER | (15) | Cumulative Revaluation Factor | |
ASSET_TAG | VARCHAR2 | (30) | Asset Tag | |
BALANCING_SEGMENT | VARCHAR2 | (30) | Balancing Segment Qualifier Value | |
SERIAL_NO | NUMBER | (15) | Serial Number | |
DPIS | DATE | Date Placed in Service | ||
LIFE_MONTHS | NUMBER | (15) | Life In Months | |
STL_RATE | NUMBER | (15) | Straightline Depreciation Rate | |
DEPRECIATION_METHOD | VARCHAR2 | (30) | Depreciation Method | |
CONC_ASSET_KEY | VARCHAR2 | (240) | Concatenated Asset Key | |
CONC_LOCATION | VARCHAR2 | (240) | Concatenated Location | |
COST_ACCT | VARCHAR2 | (30) | Asset Cost Account | |
IAC_REVAL_RESV_ACCT | NUMBER | IAC Revaluation Reserve account value | ||
DEPRN_RES_ACCT | NUMBER | Depreciation Reserve account value | ||
DEPRN_BACKLOG_ACCT | NUMBER | Depreciation Backlog account value | ||
GEN_FUND_ACCT | NUMBER | General Fund Account Value | ||
DEPRN_EXP_ACCT | NUMBER | Depreciation Expense Account Value | ||
OPER_EXP_ACCT | NUMBER | Operating Expense Account Value | ||
CONCAT_CATEGORY | VARCHAR2 | (600) | This contains the concatenated segement values | |
CREATED_BY | NUMBER | (15) | Yes | Standard who column - user who created this row (foreign key to FND_USER.USER_ID). |
CREATION_DATE | DATE | Yes | Standard who column - date when this row was created. | |
LAST_UPDATE_LOGIN | NUMBER | 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) | Yes | Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID). |
LAST_UPDATE_DATE | DATE | Yes | Standard Who column - date when a user last updated this row. |
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;
IGI.IGI_IAC_ASSET_REP_ITF does not reference any database object
IGI.IGI_IAC_ASSET_REP_ITF is referenced by following:
|
|
|