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

Object Details

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

View Type

A Business Intelligence System view

Base 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
PERSON_ID	NUMBER	(15)	Yes	Person ID
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
,      PERSON_ID
,      PREF_LENDER_ID
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
FROM APPS.IGFBV_FFELP_PREFERRED_LENDERS;

Dependencies

[top of page]

APPS.IGFBV_FFELP_PREFERRED_LENDERS references the following:

APPS: IGF_SL_CL_PREF_LENDERS

APPS.IGFBV_FFELP_PREFERRED_LENDERS is not referenced by any database object