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_XLA_LINES_GT

Object Details

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

Temporary Table Details

IGI.IGI_IAC_XLA_LINES_GT is a global temporary table. The current session is able see data that it placed in the table but other sessions cannot. Data in the table is temporary. It has a data duration of SYS$TRANSACTION. Data is removed at the end of this period.

Storage Details

Tablespace:
PCT Free:	10
PCT Used:	40

Indexes

Index	Type	Uniqueness	Tablespace	Column
IGI_IAC_XLA_LINES_GT_U1	NORMAL	UNIQUE		IAC_EVENT_ID IAC_LINE_NUMBER

Columns

Name	Datatype	Length
IAC_EVENT_ID	NUMBER	(38)
IAC_LINE_NUMBER	NUMBER	(38)
IAC_BOOK_TYPE_CODE	VARCHAR2	(15)
IAC_CATEGORY_ID	NUMBER	(15)
IAC_ASSET_ID	NUMBER
IAC_DISTRIBUTION_ID	NUMBER
IAC_LEDGER_ID	NUMBER	(15)
IAC_ADJUSTMENT_ID	NUMBER	(15)
IAC_CODE_COMBINATION_ID	NUMBER	(15)
IAC_AMOUNT	NUMBER
IAC_DR_CR_FLAG	VARCHAR2	(3)
IAC_ADJUSTMENT_TYPE	VARCHAR2	(15)
IAC_TRANSFER_TO_GL_FLAG	VARCHAR2	(1)
IAC_UNITS_ASSIGNED	NUMBER
IAC_PERIOD_COUNTER	NUMBER
IAC_ADJUSTMENT_OFFSET_TYPE	VARCHAR2	(15)
IAC_REPORT_CCID	NUMBER
IAC_TRANSACTION_HEADER_ID	NUMBER	(15)
IAC_ADJUSTMENT_ID_OUT	NUMBER	(15)
IAC_TRANSACTION_TYPE_CODE	VARCHAR2	(20)
IAC_TRANSACTION_SUB_TYPE	VARCHAR2	(15)
IAC_TRANSACTION_DATE_ENTERED	DATE
IAC_MASS_REFERENCE_ID	NUMBER	(15)
IAC_ADJ_DEPRN_START_DATE	DATE
IAC_ADJUSTMENT_STATUS	VARCHAR2	(15)
IAC_REVALUATION_TYPE_FLAG	VARCHAR2	(1)
IAC_ADJUSTMENT_TYPE_MEANING	VARCHAR2	(80)
IAC_TRANSACTION_TYPE_MEANING	VARCHAR2	(80)
IAC_GL_JE_SOURCE	VARCHAR2	(25)
IAC_JE_DEPRN_CATEGORY	VARCHAR2	(25)
IAC_JE_REVAL_CATEGORY	VARCHAR2	(25)
IAC_JE_TXN_CATEGORY	VARCHAR2	(25)
IAC_PERIOD_NAME	VARCHAR2	(15)
IAC_PERIOD_CLOSE_DATE	DATE
IAC_REVERSAL_FLAG	VARCHAR2	(1)
IAC_ACCOUNTING_DATE	DATE
IAC_BACKLOG_DEPRN_RSV_CCID	NUMBER	(15)
IAC_OPERATING_EXPENSE_CCID	NUMBER	(15)
IAC_GENERAL_FUND_CCID	NUMBER	(15)
IAC_REVAL_RESERVE_CCID	NUMBER	(15)
IAC_REVAL_RESERVE_RET_CCID	NUMBER	(15)
IAC_INTERCO_AP_CCID	NUMBER	(15)
IAC_INTERCO_AR_CCID	NUMBER	(15)
IAC_ASSET_COST_CCID	NUMBER	(15)
IAC_DEPRN_RESERVE_CCID	NUMBER	(15)
IAC_DEPRN_EXPENSE_CCID	NUMBER	(15)
IAC_NBV_RETIRED_GAIN_CCID	NUMBER	(15)
IAC_DEFAULT_CCID	NUMBER	(15)
IAC_ADJUSTMENT_LINE_ID	NUMBER
IAC_CURRENCY_CODE	VARCHAR2	(15)
IAC_DISTRIBUTION_TYPE_CODE	VARCHAR2	(30)

Query Text

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


SELECT IAC_EVENT_ID
,      IAC_LINE_NUMBER
,      IAC_BOOK_TYPE_CODE
,      IAC_CATEGORY_ID
,      IAC_ASSET_ID
,      IAC_DISTRIBUTION_ID
,      IAC_LEDGER_ID
,      IAC_ADJUSTMENT_ID
,      IAC_CODE_COMBINATION_ID
,      IAC_AMOUNT
,      IAC_DR_CR_FLAG
,      IAC_ADJUSTMENT_TYPE
,      IAC_TRANSFER_TO_GL_FLAG
,      IAC_UNITS_ASSIGNED
,      IAC_PERIOD_COUNTER
,      IAC_ADJUSTMENT_OFFSET_TYPE
,      IAC_REPORT_CCID
,      IAC_TRANSACTION_HEADER_ID
,      IAC_ADJUSTMENT_ID_OUT
,      IAC_TRANSACTION_TYPE_CODE
,      IAC_TRANSACTION_SUB_TYPE
,      IAC_TRANSACTION_DATE_ENTERED
,      IAC_MASS_REFERENCE_ID
,      IAC_ADJ_DEPRN_START_DATE
,      IAC_ADJUSTMENT_STATUS
,      IAC_REVALUATION_TYPE_FLAG
,      IAC_ADJUSTMENT_TYPE_MEANING
,      IAC_TRANSACTION_TYPE_MEANING
,      IAC_GL_JE_SOURCE
,      IAC_JE_DEPRN_CATEGORY
,      IAC_JE_REVAL_CATEGORY
,      IAC_JE_TXN_CATEGORY
,      IAC_PERIOD_NAME
,      IAC_PERIOD_CLOSE_DATE
,      IAC_REVERSAL_FLAG
,      IAC_ACCOUNTING_DATE
,      IAC_BACKLOG_DEPRN_RSV_CCID
,      IAC_OPERATING_EXPENSE_CCID
,      IAC_GENERAL_FUND_CCID
,      IAC_REVAL_RESERVE_CCID
,      IAC_REVAL_RESERVE_RET_CCID
,      IAC_INTERCO_AP_CCID
,      IAC_INTERCO_AR_CCID
,      IAC_ASSET_COST_CCID
,      IAC_DEPRN_RESERVE_CCID
,      IAC_DEPRN_EXPENSE_CCID
,      IAC_NBV_RETIRED_GAIN_CCID
,      IAC_DEFAULT_CCID
,      IAC_ADJUSTMENT_LINE_ID
,      IAC_CURRENCY_CODE
,      IAC_DISTRIBUTION_TYPE_CODE
FROM IGI.IGI_IAC_XLA_LINES_GT;

Dependencies

[top of page]

IGI.IGI_IAC_XLA_LINES_GT does not reference any database object

IGI.IGI_IAC_XLA_LINES_GT is referenced by following:

APPS: IGI_IAC_XLA_LINES_GT