[Home] [Help] [Dependency Information]
Object Name: | IGI_IAC_PROJ_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 |
---|---|---|---|---|
PROJECTION_ID | NUMBER | (15) | Projection Identifier | |
BOOK_TYPE_CODE | VARCHAR2 | (15) | Book Type identifier | |
START_PERIOD | VARCHAR2 | (15) | Start Period for projection | |
END_PERIOD | VARCHAR2 | (15) | End period for projection | |
PROJ_PERIOD | VARCHAR2 | (15) | Projection period | |
FISCAL_YEAR | NUMBER | Fiscal Year of the Projection period | ||
PERIODIC_INDEX | NUMBER | Periodic revaluation index | ||
REVAL_INDEX | NUMBER | Cost revaluation index | ||
REVAL_PERIOD_NAME | VARCHAR2 | (15) | Catchup revaluation period name | |
COMPANY | VARCHAR2 | (30) | Balancing account segment value | |
COST_CENTER | VARCHAR2 | (30) | Cost center account segment value | |
CATEGORY_ID | NUMBER | Category identifier | ||
MAJOR_CATEGORY | VARCHAR2 | (30) | Major category | |
MINOR_CATEGORY | VARCHAR2 | (30) | Minor category | |
CATEGORY_DESC | VARCHAR2 | (80) | Category description | |
ASSET_NUMBER | VARCHAR2 | (30) | Asset Number | |
ASSET_DESC | VARCHAR2 | (80) | Asset description | |
DEPRN_PERIOD | NUMBER | Periodic depreciation projected amount | ||
DEPRN_YTD | NUMBER | Year to Date depreciation projected amount | ||
LATEST_REVAL_COST | NUMBER | Latest revaluation cost of the asset | ||
EXCEPTION_CODE | VARCHAR2 | (30) | Projection exception code | |
EXCEPTION_DESC | VARCHAR2 | (255) | Projection exception code description | |
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). | ||
SET_OF_BOOKS_ID | NUMBER | Set of Books identifier | ||
CREATED_BY | NUMBER | 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 | Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID). | ||
LAST_UPDATED_BY | NUMBER | 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. | ||
CATEGORY | VARCHAR2 | (500) | Concatenated category name | |
FUNCTIONAL_CURRENCY_CODE | VARCHAR2 | (30) | Functional currency code | |
ORGANIZATION_NAME | VARCHAR2 | (80) | Organization name | |
PERIOD_COUNTER | NUMBER | Projection period counter |
Cut, paste (and edit) the following text to query this object:
SELECT PROJECTION_ID
, BOOK_TYPE_CODE
, START_PERIOD
, END_PERIOD
, PROJ_PERIOD
, FISCAL_YEAR
, PERIODIC_INDEX
, REVAL_INDEX
, REVAL_PERIOD_NAME
, COMPANY
, COST_CENTER
, CATEGORY_ID
, MAJOR_CATEGORY
, MINOR_CATEGORY
, CATEGORY_DESC
, ASSET_NUMBER
, ASSET_DESC
, DEPRN_PERIOD
, DEPRN_YTD
, LATEST_REVAL_COST
, EXCEPTION_CODE
, EXCEPTION_DESC
, REQUEST_ID
, SET_OF_BOOKS_ID
, CREATED_BY
, CREATION_DATE
, LAST_UPDATE_LOGIN
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
, CATEGORY
, FUNCTIONAL_CURRENCY_CODE
, ORGANIZATION_NAME
, PERIOD_COUNTER
FROM IGI.IGI_IAC_PROJ_REP_ITF;
IGI.IGI_IAC_PROJ_REP_ITF does not reference any database object
IGI.IGI_IAC_PROJ_REP_ITF is referenced by following:
|
|
|