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_V

Object Details

Object Name:	IGF_SL_LOANS_V
Object Type:	VIEW
Owner:	APPS
FND Design Data:	IGF.IGF_SL_LOANS_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)
LOAN_ID	NUMBER	(15)	Yes
SEQ_NUM	NUMBER	(15)
BASE_ID	NUMBER	(10)	Yes
AWARD_ID	NUMBER	(15)	Yes
STUDENT_ID	NUMBER	(15)	Yes
PERSON_NUMBER	VARCHAR2	(30)	Yes
FULL_NAME	VARCHAR2	(360)	Yes
S_SSN	VARCHAR2	(20)
FUND_ID	NUMBER	(15)	Yes
CI_CAL_TYPE	VARCHAR2	(10)	Yes	Indicates the code for the award year calender type, used within the operating unit
CI_SEQUENCE_NUMBER	NUMBER	(6)	Yes	Indicates a unique identifier for the award year calender instance
CI_START_DT	DATE		Yes	Indicates the award year start date
CI_END_DT	DATE		Yes	Indicates the award year end date
CI_ALTERNATE_CODE	VARCHAR2	(10)		Indicates the alternate short reference code for identifying a award year calendar instance
LOAN_TYPE	VARCHAR2	(30)	Yes
LOAN_TYPE_NUM	VARCHAR2	(70)
FUND_SOURCE	VARCHAR2	(30)	Yes
FUND_TYPE	VARCHAR2	(30)	Yes
SYS_FUND_TYPE	VARCHAR2	(30)	Yes
FED_FUND_CODE	VARCHAR2	(30)	Yes
LOAN_AMT_OFFERED	NUMBER	(12)
LOAN_AMT_ACCEPTED	NUMBER	(12)
LOAN_NUMBER	VARCHAR2	(30)
LOAN_PER_BEGIN_DATE	DATE		Yes
LOAN_PER_END_DATE	DATE		Yes
LOAN_STATUS	VARCHAR2	(30)	Yes
LOAN_STATUS_DATE	DATE
LOAN_CHG_STATUS	VARCHAR2	(30)
LOAN_CHG_STATUS_DATE	DATE
ACTIVE	VARCHAR2	(1)	Yes
ACTIVE_DATE	DATE		Yes
BORW_DETRM_CODE	VARCHAR2	(30)		For borrower's determination for payee for the excess credit amount.Valid values are Pay to Borrower,Pay to Student and Place on Account
CREATED_BY	NUMBER	(15)	Yes
CREATION_DATE	DATE		Yes
LAST_UPDATED_BY	NUMBER	(15)	Yes
LAST_UPDATE_DATE	DATE		Yes
LAST_UPDATE_LOGIN	NUMBER	(15)
REQUEST_ID	NUMBER	(15)
PROGRAM_APPLICATION_ID	NUMBER	(15)
PROGRAM_ID	NUMBER	(15)
PROGRAM_UPDATE_DATE	DATE
LOAN_STATUS_DESC	VARCHAR2	(4000)
LOAN_CHG_STATUS_DESC	VARCHAR2	(4000)
LEGACY_RECORD_FLAG	VARCHAR2	(1)		Indicates whether the record was imported through a legacy process or not
EXTERNAL_LOAN_ID_TXT	VARCHAR2	(30)		External Loan Number. This Loan Number would be updated from School Certification Request for FELP Loans

Query Text

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


SELECT ROW_ID
,      LOAN_ID
,      SEQ_NUM
,      BASE_ID
,      AWARD_ID
,      STUDENT_ID
,      PERSON_NUMBER
,      FULL_NAME
,      S_SSN
,      FUND_ID
,      CI_CAL_TYPE
,      CI_SEQUENCE_NUMBER
,      CI_START_DT
,      CI_END_DT
,      CI_ALTERNATE_CODE
,      LOAN_TYPE
,      LOAN_TYPE_NUM
,      FUND_SOURCE
,      FUND_TYPE
,      SYS_FUND_TYPE
,      FED_FUND_CODE
,      LOAN_AMT_OFFERED
,      LOAN_AMT_ACCEPTED
,      LOAN_NUMBER
,      LOAN_PER_BEGIN_DATE
,      LOAN_PER_END_DATE
,      LOAN_STATUS
,      LOAN_STATUS_DATE
,      LOAN_CHG_STATUS
,      LOAN_CHG_STATUS_DATE
,      ACTIVE
,      ACTIVE_DATE
,      BORW_DETRM_CODE
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      REQUEST_ID
,      PROGRAM_APPLICATION_ID
,      PROGRAM_ID
,      PROGRAM_UPDATE_DATE
,      LOAN_STATUS_DESC
,      LOAN_CHG_STATUS_DESC
,      LEGACY_RECORD_FLAG
,      EXTERNAL_LOAN_ID_TXT
FROM APPS.IGF_SL_LOANS_V;

Dependencies

[top of page]

APPS.IGF_SL_LOANS_V references the following:

APPS: HZ_PARTIES; 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; IGS_CA_INST; IGS_PE_ALT_PERS_ID; IGS_PE_PERSON_ID_TYP

APPS.IGF_SL_LOANS_V is referenced by following:

APPS: IGF_DB_DISB - show dependent code; IGF_DB_DL_RECONC - show dependent code; IGF_SL_CL_CHG_PRC - show dependent code; IGF_SL_CL_ORIG - show dependent code; IGF_SL_DL_PNOTE_ACK - show dependent code; IGF_SL_DL_PRINT_MANIFEST - show dependent code; IGF_SL_DL_PRINT_MANIFEST - show dependent code; IGF_SL_DL_PRINT_PNOTE - show dependent code; IGF_SL_DL_PRINT_PNOTE - show dependent code; IGF_SL_DL_RECORD - show dependent code; IGF_SL_REJ_WF - show dependent code