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

TABLE: IPA.IPA_INTEREST_BATCH_DETAILS

Object Details
Object Name: IPA_INTEREST_BATCH_DETAILS
Object Type: TABLE
Owner: IPA
FND Design Data: TableIPA.IPA_INTEREST_BATCH_DETAILS
Subobject Name:
Status: VALID


Table to store the transaction source audit information for the Capitalized interest lines.


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
IPA_INTEREST_BATCH_DETAILS_U1 NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnINTEREST_BATCH_DETAIL_ID
IPA_INTEREST_BATCH_DETAILS_N1 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnINTEREST_BATCH_ID
Columns
Name Datatype Length Mandatory Comments
INTEREST_BATCH_DETAIL_ID NUMBER (15) Yes System Generated ID
SOURCE_TASK_ID NUMBER (15)
Source task
RATE_CODE VARCHAR2 (25)
Rate name
RATE_APPLIED NUMBER (15)
Rate applied
INTEREST_TYPE VARCHAR2 (1)
Interest type indicates Simple or Compound.
PERIOD VARCHAR2 (15)
GL Period of Interest
INTEREST_RATE_TYPE VARCHAR2 (30)
Obsolete.
INTEREST_BATCH_ID NUMBER (15) Yes Interest Batch
EXPENDITURE_ITEM_ID NUMBER (15) Yes Source exp lines on which interest is applied
EXPENDITURE_AMOUNT NUMBER (15)
Expenditure amount on which interest is applied
Query Text

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


SELECT INTEREST_BATCH_DETAIL_ID
,      SOURCE_TASK_ID
,      RATE_CODE
,      RATE_APPLIED
,      INTEREST_TYPE
,      PERIOD
,      INTEREST_RATE_TYPE
,      INTEREST_BATCH_ID
,      EXPENDITURE_ITEM_ID
,      EXPENDITURE_AMOUNT
FROM IPA.IPA_INTEREST_BATCH_DETAILS;

Dependencies

[top of page]

IPA.IPA_INTEREST_BATCH_DETAILS does not reference any database object

IPA.IPA_INTEREST_BATCH_DETAILS is referenced by following:

SchemaIPA
ViewIPA_INTEREST_BATCH_DETAILS#