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]

VIEW: APPS.IGSBV_PAY_PLAN_INSTALLMENTS

Object Details

Object Name:	IGSBV_PAY_PLAN_INSTALLMENTS
Object Type:	VIEW
Owner:	APPS
FND Design Data:	IGS.IGSBV_PAY_PLAN_INSTALLMENTS
Subobject Name:
Status:	VALID

View Type

A Business Intelligence System view

Holds information of Student Payment Plan Installments

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
INSTALLMENT_IDENTIFIER	NUMBER		Yes	Installment identifier
STUDENT_PLAN_IDENTIFIER	NUMBER		Yes	Student plan identifier
INSTALLMENT_LINE_NUMBER	NUMBER		Yes	Installment line number
DUE_DAY	NUMBER		Yes	Day of month, when installment is due
_LA:DUE_MONTH	CHAR	(56)		Due month
DUE_YEAR	NUMBER		Yes	Due year
DUE_DATE	DATE		Yes	Due date for the installment
INSTALLMENT_AMOUNT	NUMBER		Yes	Installment amount
DUE_AMOUNT	NUMBER		Yes	Installment amount due
PENALTY_FLAG	VARCHAR2	(1)		Flag for Late Fee charge on a particular installment
PERSON_IDENTIFIER	NUMBER	(15)	Yes	Student identifier
PERSON_NUMBER	VARCHAR2	(30)	Yes	Student number
PERSON_NAME	VARCHAR2	(360)	Yes	Student name
PAYMENT_PLAN_NAME	VARCHAR2	(60)	Yes	Payment plan name
PAYMENT_PLAN_START_DATE	DATE		Yes	Payment plan start date
PAYMENT_PLAN_END_DATE	DATE		Yes	Payment plan end date
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

Query Text

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


SELECT INSTALLMENT_IDENTIFIER
,      STUDENT_PLAN_IDENTIFIER
,      INSTALLMENT_LINE_NUMBER
,      DUE_DAY
,      _LA:DUE_MONTH
,      DUE_YEAR
,      DUE_DATE
,      INSTALLMENT_AMOUNT
,      DUE_AMOUNT
,      PENALTY_FLAG
,      PERSON_IDENTIFIER
,      PERSON_NUMBER
,      PERSON_NAME
,      PAYMENT_PLAN_NAME
,      PAYMENT_PLAN_START_DATE
,      PAYMENT_PLAN_END_DATE
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
FROM APPS.IGSBV_PAY_PLAN_INSTALLMENTS;

Dependencies

[top of page]

APPS.IGSBV_PAY_PLAN_INSTALLMENTS references the following:

APPS: HZ_PARTIES; IGS_FI_PP_INSTLMNTS; IGS_FI_PP_STD_ATTRS

APPS.IGSBV_PAY_PLAN_INSTALLMENTS is not referenced by any database object