View: IGF_SL_CL_RECIPIENT_V

View Text

SELECT RCPT.ROWID ROW_ID
, RCPT.RCPT_ID RCPT_ID
, RCPT.LENDER_ID LENDER_ID
, LND.DESCRIPTION LEND_DESCRIPTION
, NULL DUNS_LENDER_ID
, RCPT.LEND_NON_ED_BRC_ID LEND_NON_ED_BRC_ID
, LNDB.DESCRIPTION LEND_BRC_DESCRIPTION
, RCPT.GUARANTOR_ID GUARANTOR_ID
, GUARN.DESCRIPTION GUARN_DESCRIPTION
, NULL DUNS_GUARNT_ID
, RCPT.RECIPIENT_ID RECIPIENT_ID
, RCPV.RECIP_DESCRIPTION RECIP_DESCRIPTION
, NULL DUNS_RCPT_ID
, RCPT.RECIPIENT_TYPE RECIPIENT_TYPE
, RCPT.RECIP_NON_ED_BRC_ID RECIP_NON_ED_BRC_ID
, RCPV.RECIP_BRC_DESCRIPTION RECIP_BRC_DESCRIPTION
, RCPT.ENABLED ENABLED
, RCPT.CREATED_BY CREATED_BY
, RCPT.CREATION_DATE CREATION_DATE
, RCPT.LAST_UPDATED_BY LAST_UPDATED_BY
, RCPT.LAST_UPDATE_DATE LAST_UPDATE_DATE
, RCPT.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, RCPT.RELATIONSHIP_CD
, RCPT.RELATIONSHIP_CD_DESC
, RCPT.PREFERRED_FLAG
FROM IGF_SL_CL_RECIPIENT RCPT
, IGF_SL_LENDER LND
, IGF_SL_LENDER_BRC LNDB
, IGF_SL_GUARANTOR GUARN
, IGF_SL_RECIPIENT_ALL_V RCPV
WHERE RCPT.LENDER_ID = LND.LENDER_ID
AND RCPT.LENDER_ID = LNDB.LENDER_ID(+)
AND NVL(RCPT.LEND_NON_ED_BRC_ID
, '*') = NVL(LNDB.LEND_NON_ED_BRC_ID
, '*')
AND RCPT.GUARANTOR_ID = GUARN.GUARANTOR_ID
AND RCPT.RECIPIENT_ID = RCPV.RECIPIENT_ID
AND RCPT.RECIPIENT_TYPE= RCPV.RECIPIENT_TYPE
AND NVL(RCPT.RECIP_NON_ED_BRC_ID
, '*') = NVL(RCPV.RECIP_NON_ED_BRC_ID
, '*')

Columns