View: IGF_SL_CL_PREF_LENDERS_V

Product:	IGF - Financial Aid
Description:	FFELP Preferred Lender Assignment View
Implementation/DBA Data:	APPS.IGF_SL_CL_PREF_LENDERS_V

View Text

SELECT CLPRL.ROWID
, CLPRL.CLPRL_ID
, CLPRL.PERSON_ID
, CLPRL.RELATIONSHIP_CD
, RECP.RELATIONSHIP_CD_DESC
, CLPRL.START_DATE
, CLPRL.END_DATE
, CLPRL.OBJECT_VERSION_NUMBER
, CLPRL.CREATED_BY
, CLPRL.CREATION_DATE
, CLPRL.LAST_UPDATED_BY
, CLPRL.LAST_UPDATE_DATE
, CLPRL.LAST_UPDATE_LOGIN
, CLPRL.PROGRAM_APPLICATION_ID
, CLPRL.PROGRAM_ID
, CLPRL.PROGRAM_UPDATE_DATE
, CLPRL.REQUEST_ID
FROM IGF_SL_CL_PREF_LENDERS CLPRL
, IGF_SL_CL_RECIPIENT RECP
WHERE RECP.RELATIONSHIP_CD = CLPRL.RELATIONSHIP_CD

Columns