View: IGF_SL_RECIPIENT_ALL_V

Product:	IGF - Financial Aid
Description:
Implementation/DBA Data:	APPS.IGF_SL_RECIPIENT_ALL_V

View Text

SELECT LND.LENDER_ID LENDER_ID
, LND.DESCRIPTION LEND_DESCRIPTION
, LND.DUNS_LENDER_ID DUNS_LENDER_ID
, 'LND' RECIPIENT_TYPE
, LND.ENABLED LEND_ENABLED
, LNDB.LEND_NON_ED_BRC_ID LEND_NON_ED_BRC_ID
, LNDB.DESCRIPTION LEND_BRC_DESCRIPTION
, LNDB.ENABLED LEND_BRC_ENABLED
FROM IGF_SL_LENDER LND
, IGF_SL_LENDER_BRC LNDB
WHERE LND.LENDER_ID = LNDB.LENDER_ID(+) UNION ALL SELECT GUARANTOR_ID GUARANTOR_ID
, DESCRIPTION DESCRIPTION
, DUNS_GUARNT_ID DUNS_GUARNT_ID
, 'GUARN' RECIPIENT_TYPE
, ENABLED ENABLED
, '' NON_ED_BRC_ID
, '' BRC_DESCRIPTION
, '' BRC_ENABLED
FROM IGF_SL_GUARANTOR UNION ALL SELECT SRVC.SERVICER_ID SERVICER_ID
, SRVC.DESCRIPTION SRVC_DESCRIPTION
, SRVC.DUNS_SERVICER_ID DUNS_SERVICER_ID
, 'SRVC' RECIPIENT_TYPE
, SRVC.ENABLED SRVC_ENABLED
, SRVB.SRVC_NON_ED_BRC_ID SRVC_NON_ED_BRC_ID
, SRVB.DESCRIPTION SRVC_BRC_DESCRIPTION
, SRVB.ENABLED SRVB_ENABLED
FROM IGF_SL_SERVICER SRVC
, IGF_SL_SERVICER_BRC SRVB
WHERE SRVC.SERVICER_ID = SRVB.SERVICER_ID(+)

Columns