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

Object Details

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

View Type

A Business Intelligence System view

Full View for the Entity that holds Preferred FFELP Lenders

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
RELATIONSHIP_CODE	VARCHAR2	(30)	Yes	Relationship Code
START_DATE	DATE		Yes	Relationship Start Date
END_DATE	DATE			Relationship End Date
RELATIONSHIP_DESCRIPTION	VARCHAR2	(80)		Relationship Description
RECIPIENT_TYPE	VARCHAR2	(30)	Yes	Indicates lender, guarantor, or servicer
PERSON_NUMBER	VARCHAR2	(30)	Yes	Person Number
FIRST_NAME	VARCHAR2	(150)		Person First Name
LAST_NAME	VARCHAR2	(150)		Person Last Name
MIDDLE_NAME	VARCHAR2	(60)		Person Middle Name
PERSON_ID	NUMBER	(15)	Yes	Person ID
LENDER_ID	VARCHAR2	(30)	Yes	Identifier for lender
LEND_NON_ED_BRC_ID	VARCHAR2	(30)		Indicates non-ED branch for particular lender
GUARANTOR_ID	VARCHAR2	(30)	Yes	Identifier for guarantor
RECIPIENT_ID	VARCHAR2	(30)	Yes	Indicates either lender, guarantor, or servicer identifier
RECIP_NON_ED_BRC_ID	VARCHAR2	(30)		Indicates non-ED branch of lender or servicer selected as recipient
PREF_LENDER_ID	NUMBER		Yes	Preferred Lender ID. Sequence Generated Primary Key
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

Query Text

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


SELECT RELATIONSHIP_CODE
,      START_DATE
,      END_DATE
,      RELATIONSHIP_DESCRIPTION
,      RECIPIENT_TYPE
,      PERSON_NUMBER
,      FIRST_NAME
,      LAST_NAME
,      MIDDLE_NAME
,      PERSON_ID
,      LENDER_ID
,      LEND_NON_ED_BRC_ID
,      GUARANTOR_ID
,      RECIPIENT_ID
,      RECIP_NON_ED_BRC_ID
,      PREF_LENDER_ID
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
FROM APPS.IGFFV_FFELP_PREFERRED_LENDERS;

Dependencies

[top of page]

APPS.IGFFV_FFELP_PREFERRED_LENDERS references the following:

APPS: HZ_PARTIES; IGF_SL_CL_PREF_LENDERS; IGF_SL_CL_RECIPIENT

APPS.IGFFV_FFELP_PREFERRED_LENDERS is not referenced by any database object