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

TABLE: IPA.IPA_PROJECT_INTERESTS

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


Table to store the capitalized interest overrides at the project level


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
IPA_PROJECT_INTERESTS_U1 NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnPROJECT_INTEREST_ID
IPA_PROJECT_INTERESTS_N1 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnRATE_CODE
Columns
Name Datatype Length Mandatory Comments
PROJECT_INTEREST_ID NUMBER (15) Yes System Generated ID
RATE_CODE VARCHAR2 (25) Yes Rate structure name
PROJECT_ID NUMBER (15) Yes Project to which this rate is assigned
CAPITALIZE_INTEREST VARCHAR2 (1) Yes Falg to control application interest at the Project level
EFFECTIVE_DATE_FROM DATE
Yes Begin Date from which this assignment is valid
EFFECTIVE_DATE_TO DATE

End Date to which this assignment is valid
THRESHOLD_AMOUNT NUMBER

Threshold amount above which Interest needs to be applied
COMMENTS VARCHAR2 (100)
Comments
CREATED_BY NUMBER (15) Yes Standard Who Column
CREATION_DATE DATE
Yes Standard Who Column
LAST_UPDATE_DATE DATE
Yes Standard Who Column
LAST_UPDATED_BY NUMBER (15) Yes Standard Who Column
LAST_UPDATE_LOGIN NUMBER (15)
Standard Who Column
Query Text

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


SELECT PROJECT_INTEREST_ID
,      RATE_CODE
,      PROJECT_ID
,      CAPITALIZE_INTEREST
,      EFFECTIVE_DATE_FROM
,      EFFECTIVE_DATE_TO
,      THRESHOLD_AMOUNT
,      COMMENTS
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
FROM IPA.IPA_PROJECT_INTERESTS;

Dependencies

[top of page]

IPA.IPA_PROJECT_INTERESTS does not reference any database object

IPA.IPA_PROJECT_INTERESTS is referenced by following:

SchemaIPA
ViewIPA_PROJECT_INTERESTS#