[Home] [Help] [Dependency Information]
Object Name: | IGI_MHC_TRANSACTION_HEADERS |
---|---|
Object Type: | TABLE |
Owner: | IGI |
FND Design Data: | IGI.IGI_MHC_TRANSACTION_HEADERS |
Subobject Name: | |
Status: | VALID |
IGI_MHC_TRANSACTION_HEADER is an extension to the Oracle Assets table FA_TRANSACTION_HEADERS.
After many of the Oracle Assets processes, a Modified Historic Cost Accounting post processor is called which updates data as required by the Modified Historic Cost Accounting functionality. To track these processes, a record is inserted into IGI_MHC_TRANSACTION_HEADER for each record in FA_TRANSACTION_HEADERS.
The PROCESS_STATUS is marked as COMPLETE, and the TRANSACTION_CORRECTED_FLAG set to 'Yes' if the process completes successfully.
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
IGI_MHC_TRANS_HEADER_N1 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX | TRANSACTION_HEADER_ID |
IGI_MHC_TRANS_HEADER_N2 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX | ASSET_ID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
TRANSACTION_HEADER_ID | NUMBER | (15) | Yes | TRANSACTION_HEADER_ID from the FA_TRANSACTION_HEADERS table |
ASSET_ID | NUMBER | (15) | Yes | Asset Identifier |
PROCESS_ID | NUMBER | (15) | Id of the process that is currently running or was last run on the transaction | |
PROCESS_STATUS | VARCHAR2 | (15) | Status of the process that is currently running or was last run on the transaction. The status is set to COMPLETE once the process has completed. | |
PROCESS_RUN_MODE | VARCHAR2 | (15) | Mode of the process that is currently running or was last run on the transaction. The values could be Live (L) or Preview (P) | |
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_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. | ||
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). | |
TRANSACTION_CORRECTED_FLAG | VARCHAR2 | (3) | Flag indicating if the Modified Historic Cost Accounting correction processes have been run on the transaction. |
Cut, paste (and edit) the following text to query this object:
SELECT TRANSACTION_HEADER_ID
, ASSET_ID
, PROCESS_ID
, PROCESS_STATUS
, PROCESS_RUN_MODE
, CREATED_BY
, CREATION_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN
, TRANSACTION_CORRECTED_FLAG
FROM IGI.IGI_MHC_TRANSACTION_HEADERS;
IGI.IGI_MHC_TRANSACTION_HEADERS does not reference any database object
IGI.IGI_MHC_TRANSACTION_HEADERS is referenced by following:
|
|
|