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_PLUS_LOAN_DETAILS_V

Object Details

Object Name:	IGF_SL_PLUS_LOAN_DETAILS_V
Object Type:	VIEW
Owner:	APPS
FND Design Data:	IGF.IGF_SL_PLUS_LOAN_DETAILS_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
LOAN_NUMBER	VARCHAR2	(30)		Loan Number
LOAN_TYPE_NUM_TXT	VARCHAR2	(70)		Loan Type Number. Fund Code concatenated with loan sequence number.
LOAN_PER_BEGIN_DATE	DATE		Yes	Loan Period Begin Date
LOAN_PER_END_DATE	DATE		Yes	Loan Period End Date
LOAN_STATUS	VARCHAR2	(30)	Yes	Loan Status Code
LOAN_STATUS_DESC	VARCHAR2	(4000)		Loan Status Code Description
LOAN_STATUS_DATE	DATE			Loan Status Date
LOAN_CHG_STATUS	VARCHAR2	(30)		Loan Change Status Code
LOAN_CHG_STATUS_DESC	VARCHAR2	(4000)		Loan Change Status Code Description
LOAN_CHG_STATUS_DATE	DATE			Loan Change Status Date
ACTIVE	VARCHAR2	(1)	Yes	Active
ACTIVE_DATE	DATE		Yes	Active Date
BORW_DETRM_CODE	VARCHAR2	(30)		For borrower's determination for payee for the excess credit amount
BORW_DETRM	VARCHAR2	(80)		Borrower determination code meaning.
LEGACY_RECORD_FLAG	VARCHAR2	(1)		Legacy Record Flag
P_PERSON_ID	NUMBER	(15)		Borrower Person ID
STUDENT_ID	NUMBER	(15)	Yes	Student Person ID
CI_CAL_TYPE	VARCHAR2	(10)	Yes	Award Year Calendar Type
CI_SEQUENCE_NUMBER	NUMBER	(6)	Yes	Award Year Sequence Number
LOAN_ACCEPTED_AMT	NUMBER	(12)		Loan Accepted Amount
LOAN_TYPE_CODE	VARCHAR2	(30)	Yes	Loan Type Code
LOAN_TYPE_MEANING	VARCHAR2	(4000)		Loan Type Description
CI_ALTERNATE_CODE	VARCHAR2	(10)		Award Year Alternate Code
CI_START_DT	DATE		Yes	Award Year Start Date
CI_END_DT	DATE		Yes	Award Year End Date
P_PERSON_NUMBER	VARCHAR2	(30)	Yes	Person Number
P_FULL_NAME	VARCHAR2	(450)		Full Name
CREATED_BY	NUMBER	(15)	Yes	Standard Who Column
CREATION_DATE	DATE		Yes	Standard Who Column
LAST_UPDATED_BY	NUMBER	(15)	Yes	Standard Who Column
LAST_UPDATE_DATE	DATE		Yes	Standard Who Column
LAST_UPDATE_LOGIN	NUMBER	(15)		Standard Who Column
REQUEST_ID	NUMBER	(15)		Standard Who Column for Concurrent Program
PROGRAM_APPLICATION_ID	NUMBER	(15)		Standard Who Column for Concurrent Program
PROGRAM_ID	NUMBER	(15)		Standard Who Column for Concurrent Program
PROGRAM_UPDATE_DATE	DATE			Standard Who Column for Concurrent Program
EXTERNAL_LOAN_ID_TXT	VARCHAR2	(30)		External Loan Number. Used for School Certification in FFELP Loans

Query Text

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


SELECT ROW_ID
,      LOAN_ID
,      AWARD_ID
,      SEQ_NUM
,      LOAN_NUMBER
,      LOAN_TYPE_NUM_TXT
,      LOAN_PER_BEGIN_DATE
,      LOAN_PER_END_DATE
,      LOAN_STATUS
,      LOAN_STATUS_DESC
,      LOAN_STATUS_DATE
,      LOAN_CHG_STATUS
,      LOAN_CHG_STATUS_DESC
,      LOAN_CHG_STATUS_DATE
,      ACTIVE
,      ACTIVE_DATE
,      BORW_DETRM_CODE
,      BORW_DETRM
,      LEGACY_RECORD_FLAG
,      P_PERSON_ID
,      STUDENT_ID
,      CI_CAL_TYPE
,      CI_SEQUENCE_NUMBER
,      LOAN_ACCEPTED_AMT
,      LOAN_TYPE_CODE
,      LOAN_TYPE_MEANING
,      CI_ALTERNATE_CODE
,      CI_START_DT
,      CI_END_DT
,      P_PERSON_NUMBER
,      P_FULL_NAME
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      REQUEST_ID
,      PROGRAM_APPLICATION_ID
,      PROGRAM_ID
,      PROGRAM_UPDATE_DATE
,      EXTERNAL_LOAN_ID_TXT
FROM APPS.IGF_SL_PLUS_LOAN_DETAILS_V;

Dependencies

[top of page]

APPS.IGF_SL_PLUS_LOAN_DETAILS_V references the following:

APPS: IGF_AP_FA_BASE_REC; IGF_AW_AWARD; IGF_AW_FUND_CAT; IGF_AW_FUND_MAST; IGF_AW_GEN - show dependent code; IGF_SL_LOANS; IGF_SL_LOR; IGS_CA_INST; IGS_LOOKUP_VALUES; IGS_PE_PERSON_BASE_V

APPS.IGF_SL_PLUS_LOAN_DETAILS_V is not referenced by any database object