eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

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

TABLE: IGI.IGI_IAC_TRANSACTION_HEADERS

Object Details

Object Name:	IGI_IAC_TRANSACTION_HEADERS
Object Type:	TABLE
Owner:	IGI
FND Design Data:	IGI.IGI_IAC_TRANSACTION_HEADERS
Subobject Name:
Status:	VALID

IGI_IAC_TRANSACTION_HEADERS stores the details of the transactions performed against all assets

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
IGI_IAC_TRANSACTION_HEADERS_N3	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	ADJUSTMENT_ID
IGI_IAC_TRANSACTION_HEADERS_N4	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	MASS_REFERENCE_ID TRANSACTION_TYPE_CODE ADJUSTMENT_STATUS ASSET_ID
IGI_TRANSACTION_HEADERS_N1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	BOOK_TYPE_CODE ASSET_ID PERIOD_COUNTER
IGI_TRANSACTION_HEADERS_N2	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	ADJUSTMENT_ID_OUT TRANSACTION_HEADER_ID

Columns

Name	Datatype	Length	Mandatory	Comments
ADJUSTMENT_ID	NUMBER	(15)	Yes	Primary Key to record all Adjustments Transactions processed by Inflation Accounting
TRANSACTION_HEADER_ID	NUMBER	(15)		Reference to Transaction_Header_Id in FA_TRANSACTION_HEADERS
ADJUSTMENT_ID_OUT	NUMBER	(15)		Reference to Transaction_Header_Id in FA_TRANSACTION_HEADERS
TRANSACTION_TYPE_CODE	VARCHAR2	(20)	Yes	Reference to Transaction_Header_Id in FA_TRANSACTION_HEADERS for a particular transaction_id and Inflation Accounting Revaluation and Periodic Revaluation of Depreciation
TRANSACTION_DATE_ENTERED	DATE		Yes	Reference to Transaction_Date_Entered in FA_TRANSACTION_HEADERS
MASS_REFERENCE_ID	NUMBER	(15)		Reference to Mass_Reference_Id in FA_TRANSACTION_HEADERS
TRANSACTION_SUB_TYPE	VARCHAR2	(15)		Reference to Transaction_Sub_Type in FA_TRANSACTION_HEADERS
BOOK_TYPE_CODE	VARCHAR2	(15)	Yes	Book Identifier
ASSET_ID	NUMBER	(15)	Yes	Asset Identifier
CATEGORY_ID	NUMBER	(15)	Yes	Category Identifier
ADJ_DEPRN_START_DATE	DATE			Date when Inflation Accounting starts recording Depreciation of Assets
REVALUATION_TYPE_FLAG	VARCHAR2	(1)		Indexed / Professional
ADJUSTMENT_STATUS	VARCHAR2	(15)	Yes	(Preview, Run)
PERIOD_COUNTER	NUMBER		Yes	Period Counter
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	(15)		Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID).
LAST_UPDATE_DATE	DATE		Yes	Standard Who column - date when a user last updated this row.
LAST_UPDATED_BY	NUMBER	(15)	Yes	Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID).
EVENT_ID	NUMBER	(15)		Event ID

Query Text

Cut, paste (and edit) the following text to query this object:


SELECT ADJUSTMENT_ID
,      TRANSACTION_HEADER_ID
,      ADJUSTMENT_ID_OUT
,      TRANSACTION_TYPE_CODE
,      TRANSACTION_DATE_ENTERED
,      MASS_REFERENCE_ID
,      TRANSACTION_SUB_TYPE
,      BOOK_TYPE_CODE
,      ASSET_ID
,      CATEGORY_ID
,      ADJ_DEPRN_START_DATE
,      REVALUATION_TYPE_FLAG
,      ADJUSTMENT_STATUS
,      PERIOD_COUNTER
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATE_LOGIN
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      EVENT_ID
FROM IGI.IGI_IAC_TRANSACTION_HEADERS;

Dependencies

[top of page]

IGI.IGI_IAC_TRANSACTION_HEADERS does not reference any database object

IGI.IGI_IAC_TRANSACTION_HEADERS is referenced by following:

APPS: IGI_IAC_TRANSACTION_HEADERS