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: PA.PA_CINT_RATE_MULTIPLIERS

Object Details

Object Name:	PA_CINT_RATE_MULTIPLIERS
Object Type:	TABLE
Owner:	PA
FND Design Data:	PA.PA_CINT_RATE_MULTIPLIERS
Subobject Name:
Status:	VALID

Stores complied capitalized interest schedule revisions, denormalized by revision, organization and rate name. The multipliers in this table are used during the calculation and generation of Capitalized Interest transactions.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
PA_CINT_RATE_MULTIPLIERS_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	IND_RATE_SCH_REVISION_ID ORGANIZATION_ID RATE_NAME

Columns

Name	Datatype	Length	Mandatory	Comments
IND_RATE_SCH_REVISION_ID	NUMBER	(15)	Yes	Rate Schedule Revision Identifier
ORGANIZATION_ID	NUMBER	(15)	Yes	Organization Identifier
IND_RATE_SCH_ID	NUMBER	(15)	Yes	Interest Rate Schedule Identifier
RATE_NAME	VARCHAR2	(30)	Yes	Interest Rate Name
MULTIPLIER	NUMBER	(22)	Yes	Complied Interest Rate Value
LAST_UPDATE_DATE	DATE		Yes	Standard Who column
LAST_UPDATED_BY	NUMBER	(15)	Yes	Standard Who column
CREATED_BY	NUMBER	(15)	Yes	Standard Who column
CREATION_DATE	DATE		Yes	Standard Who column
LAST_UPDATE_LOGIN	NUMBER	(15)		Standard Who column
REQUEST_ID	NUMBER	(15)		Concurrent program request ID
PROGRAM_APPLICATION_ID	NUMBER	(15)		Concurrent program Application ID
PROGRAM_ID	NUMBER	(15)		Concurrent program ID
PROGRAM_UPDATE_DATE	DATE			Concurrent program update date

Query Text

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


SELECT IND_RATE_SCH_REVISION_ID
,      ORGANIZATION_ID
,      IND_RATE_SCH_ID
,      RATE_NAME
,      MULTIPLIER
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATE_LOGIN
,      REQUEST_ID
,      PROGRAM_APPLICATION_ID
,      PROGRAM_ID
,      PROGRAM_UPDATE_DATE
FROM PA.PA_CINT_RATE_MULTIPLIERS;

Dependencies

[top of page]

PA.PA_CINT_RATE_MULTIPLIERS does not reference any database object

PA.PA_CINT_RATE_MULTIPLIERS is referenced by following:

APPS: PA_CINT_RATE_MULTIPLIERS