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: JA.JAI_RGM_TERM_INSTALLMENTS

Object Details

Object Name:	JAI_RGM_TERM_INSTALLMENTS
Object Type:	TABLE
Owner:	JA
FND Design Data:	JA.JAI_RGM_TERM_INSTALLMENTS
Subobject Name:
Status:	VALID

Stores the term installments

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
JAI_RGM_TERM_INSTALLMENTS_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	TERM_INSTALLMENT_ID
JAI_RGM_TERM_INSTALLMENTS_U2	NORMAL	UNIQUE	APPS_TS_TX_IDX	TERM_ID INSTALLMENT_NUMBER
JAI_RGM_TERM_INSTALLMENTS_N1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	TERM_ID

Columns

Name	Datatype	Length	Mandatory	Comments
TERM_INSTALLMENT_ID	NUMBER		Yes	Entity identifier
TERM_ID	NUMBER		Yes	Identifier of the term
INSTALLMENT_NUMBER	NUMBER		Yes	The installment number of the current installment
CLAIM_INTERVAL	VARCHAR2	(30)	Yes	The claim interval of the current installment.
DAY_OF_CLAIM	VARCHAR2	(20)		Day on which the claim should be made.
MONTH_OF_CLAIM	VARCHAR2	(20)		Specific Month in which the claim should be made
DAY_OF_MONTH	NUMBER			Day on which the claim needs to be done
CLAIM_PERCENTAGE	NUMBER			Percentage of claim for the current installment.
CREATION_DATE	DATE		Yes	Standard Who Column
CREATED_BY	NUMBER		Yes	Standard Who Column
LAST_UPDATE_DATE	DATE		Yes	Standard Who Column
LAST_UPDATED_BY	NUMBER		Yes	Standard Who Column
LAST_UPDATE_LOGIN	NUMBER		Yes	Standard Who Column
OBJECT_VERSION_NUMBER	NUMBER			Object version Number

Query Text

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


SELECT TERM_INSTALLMENT_ID
,      TERM_ID
,      INSTALLMENT_NUMBER
,      CLAIM_INTERVAL
,      DAY_OF_CLAIM
,      MONTH_OF_CLAIM
,      DAY_OF_MONTH
,      CLAIM_PERCENTAGE
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      OBJECT_VERSION_NUMBER
FROM JA.JAI_RGM_TERM_INSTALLMENTS;

Dependencies

[top of page]

JA.JAI_RGM_TERM_INSTALLMENTS does not reference any database object

JA.JAI_RGM_TERM_INSTALLMENTS is referenced by following:

JA: JAI_RGM_TERM_INSTALLMENTS#