VIEW: APPS.IGF_SL_RECIPIENT_ALL_V

Source

View Text - Preformatted

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(+)

View Text - HTML Formatted

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(+)