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

TABLE: IGI.IGI_IAC_DET_BALANCES

Object Details
Object Name: IGI_IAC_DET_BALANCES
Object Type: TABLE
Owner: IGI
FND Design Data: TableIGI.IGI_IAC_DET_BALANCES
Subobject Name:
Status: VALID


IGI_IAC_DET_BALANCES stores the distribution level balance information whcih is made up due to Reval Reserve , Operating Account, Backlog.


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
IGI_DET_BALANCES_N1 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnADJUSTMENT_ID
ColumnDISTRIBUTION_ID
IGI_IAC_DET_BALANCES_N2 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnASSET_ID
ColumnDISTRIBUTION_ID
ColumnBOOK_TYPE_CODE
Columns
Name Datatype Length Mandatory Comments
ADJUSTMENT_ID NUMBER (15) Yes Reference to Transaction_Header_Id in FA_TRANSACTION_HEADERS
ASSET_ID NUMBER (15) Yes Asset Identifier
DISTRIBUTION_ID NUMBER (15) Yes Distribution Identifier
BOOK_TYPE_CODE VARCHAR2 (15) Yes Book Identifier
PERIOD_COUNTER NUMBER
Yes Period Counter
ADJUSTMENT_COST NUMBER
Yes Net Cost Impact
NET_BOOK_VALUE NUMBER
Yes Net Book Value of Asset
REVAL_RESERVE_COST NUMBER

Revaluation Reserve Cost
REVAL_RESERVE_BACKLOG NUMBER

Revaluation Reserve Backlog Cost
REVAL_RESERVE_GEN_FUND NUMBER

Revaluation Reserve General Fund
REVAL_RESERVE_NET NUMBER

Revaluation Reserve Net amount
OPERATING_ACCT_COST NUMBER

Operating Account Cost
OPERATING_ACCT_BACKLOG NUMBER

Operating Account Backlog amount
OPERATING_ACCT_NET NUMBER

Operating Account Net amount
OPERATING_ACCT_YTD NUMBER

Operating Account Year to Date amount
DEPRN_PERIOD NUMBER

Depreciation Period
DEPRN_YTD NUMBER

Depreciation Year to Date amount
DEPRN_RESERVE NUMBER

Depreciation Reserve amount
DEPRN_RESERVE_BACKLOG NUMBER

Depreciation Reserve Backlog amount
GENERAL_FUND_PER NUMBER

Impact of General Fund for this transaction at this point in time
GENERAL_FUND_ACC NUMBER

Accumulated General Fund at this point in time
LAST_REVAL_DATE DATE

Last Revaluation Date
CURRENT_REVAL_FACTOR NUMBER

Revaluation Factor (Current Period Index Value / Prior Period Index Value)
CUMULATIVE_REVAL_FACTOR NUMBER

Reval Factor (Base Revaluation Factor * Previous Latest Revaluation Factor)
ACTIVE_FLAG VARCHAR2 (1)
Active flag
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).
Query Text

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


SELECT ADJUSTMENT_ID
,      ASSET_ID
,      DISTRIBUTION_ID
,      BOOK_TYPE_CODE
,      PERIOD_COUNTER
,      ADJUSTMENT_COST
,      NET_BOOK_VALUE
,      REVAL_RESERVE_COST
,      REVAL_RESERVE_BACKLOG
,      REVAL_RESERVE_GEN_FUND
,      REVAL_RESERVE_NET
,      OPERATING_ACCT_COST
,      OPERATING_ACCT_BACKLOG
,      OPERATING_ACCT_NET
,      OPERATING_ACCT_YTD
,      DEPRN_PERIOD
,      DEPRN_YTD
,      DEPRN_RESERVE
,      DEPRN_RESERVE_BACKLOG
,      GENERAL_FUND_PER
,      GENERAL_FUND_ACC
,      LAST_REVAL_DATE
,      CURRENT_REVAL_FACTOR
,      CUMULATIVE_REVAL_FACTOR
,      ACTIVE_FLAG
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATE_LOGIN
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
FROM IGI.IGI_IAC_DET_BALANCES;

Dependencies

[top of page]

IGI.IGI_IAC_DET_BALANCES does not reference any database object

IGI.IGI_IAC_DET_BALANCES is referenced by following:

SchemaAPPS
SynonymIGI_IAC_DET_BALANCES