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.IGF_SL_LOANS_SUM_V

Object Details

Object Name:	IGF_SL_LOANS_SUM_V
Object Type:	VIEW
Owner:	APPS
FND Design Data:	IGF.IGF_SL_LOANS_SUM_V
Subobject Name:
Status:	VALID

View Type

A supplementary view used to simplify forms coding.

Warning: Oracle does not recommend you query or alter datausing this view. It may change dramatically in subsequent minor or major
releases.

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
ROW_ID	ROWID	(10)		Row ID of the IGF_SL_LOANS_ALL table
LOAN_ID	NUMBER	(15)	Yes	Sequence generated Loan ID
AWARD_ID	NUMBER	(15)	Yes	Sequence generated Award ID
SEQ_NUM	NUMBER	(15)		Loan Sequence Number
ORIG_BATCH_ID_TXT	VARCHAR2	(40)		Loans Origination Batch ID
LOAN_NUMBER_TXT	VARCHAR2	(30)		Loan Number
LOAN_PER_BEGIN_DATE	DATE		Yes	Loan Period Begin Date
LOAN_PER_END_DATE	DATE		Yes	Loan Period End Date
LOAN_STATUS_CODE	VARCHAR2	(30)	Yes	Loan Status Code
LOAN_STATUS_DESC	VARCHAR2	(4000)		Loan Status Code Description
LOAN_STATUS_DATE	DATE			Loan Status Date
ACTIVE_FLAG	VARCHAR2	(1)	Yes	Active
ACTIVE_DATE	DATE		Yes	Active Date
LOAN_ACCEPTED_AMT	NUMBER	(12)		Accepted Loan Amount
LOAN_PAID_AMT	NUMBER	(12)		Paid Loan Amount
BASE_ID	NUMBER	(10)	Yes	Sequence generated key to identify student record
CAL_TYPE	VARCHAR2	(10)	Yes	Award Year Calendar Type
SEQUENCE_NUMBER	NUMBER	(6)	Yes	Award Year Calendar Sequence Number
S_PERSON_ID	NUMBER	(15)	Yes	Student Person ID
S_PERSON_NUMBER	VARCHAR2	(30)	Yes	Student Person Number
S_FULL_NAME	VARCHAR2	(450)		Student Full Name
P_PERSON_ID	NUMBER	(15)		Borrower Person ID
P_PERSON_NUMBER	VARCHAR2	(30)		Borrower Person Number
P_FULL_NAME	VARCHAR2	(450)		Borrower Full Name

Query Text

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


SELECT ROW_ID
,      LOAN_ID
,      AWARD_ID
,      SEQ_NUM
,      ORIG_BATCH_ID_TXT
,      LOAN_NUMBER_TXT
,      LOAN_PER_BEGIN_DATE
,      LOAN_PER_END_DATE
,      LOAN_STATUS_CODE
,      LOAN_STATUS_DESC
,      LOAN_STATUS_DATE
,      ACTIVE_FLAG
,      ACTIVE_DATE
,      LOAN_ACCEPTED_AMT
,      LOAN_PAID_AMT
,      BASE_ID
,      CAL_TYPE
,      SEQUENCE_NUMBER
,      S_PERSON_ID
,      S_PERSON_NUMBER
,      S_FULL_NAME
,      P_PERSON_ID
,      P_PERSON_NUMBER
,      P_FULL_NAME
FROM APPS.IGF_SL_LOANS_SUM_V;

Dependencies

[top of page]

APPS.IGF_SL_LOANS_SUM_V references the following:

APPS: IGF_AP_FA_BASE_REC; IGF_AW_AWARD; IGF_AW_GEN - show dependent code; IGF_SL_LOANS; IGF_SL_LOR; IGS_PE_PERSON_BASE_V

APPS.IGF_SL_LOANS_SUM_V is not referenced by any database object