View: LNS_LOAN_PARTICIPANTS_V

Product:	LNS - Loans
Description:	View for Loan Participants Information
Implementation/DBA Data:	APPS.LNS_LOAN_PARTICIPANTS_V

View Text

SELECT PARTICIPANT.LOAN_ID
, PARTY.PARTY_NAME
, PARTICIPANT_TYPE.MEANING
, PARTY_TYPE.MEANING
, PARTY.ADDRESS1 || ' ' || PARTY.CITY || ' ' || PARTY.STATE || ' ' || PARTY.POSTAL_CODE || ' ' || TERR.TERRITORY_SHORT_NAME
, CON_PARTY.PARTY_NAME
, CON_PHONE.RAW_PHONE_NUMBER
, PARTICIPANT.HZ_PARTY_ID
, PARTICIPANT.PARTICIPANT_ID
, PARTICIPANT.CUST_ACCOUNT_ID
, PARTICIPANT.BILL_TO_ACCT_SITE_ID
, PARTICIPANT.START_DATE_ACTIVE
, PARTICIPANT.END_DATE_ACTIVE
, PARTICIPANT.ATTRIBUTE_CATEGORY
, PARTICIPANT.ATTRIBUTE1
, PARTICIPANT.ATTRIBUTE2
, PARTICIPANT.ATTRIBUTE3
, PARTICIPANT.ATTRIBUTE4
, PARTICIPANT.ATTRIBUTE5
, PARTICIPANT.ATTRIBUTE6
, PARTICIPANT.ATTRIBUTE7
, PARTICIPANT.ATTRIBUTE8
, PARTICIPANT.ATTRIBUTE9
, PARTICIPANT.ATTRIBUTE10
, PARTICIPANT.ATTRIBUTE11
, PARTICIPANT.ATTRIBUTE12
, PARTICIPANT.ATTRIBUTE13
, PARTICIPANT.ATTRIBUTE14
, PARTICIPANT.ATTRIBUTE15
, PARTICIPANT.ATTRIBUTE16
, PARTICIPANT.ATTRIBUTE17
, PARTICIPANT.ATTRIBUTE18
, PARTICIPANT.ATTRIBUTE19
, PARTICIPANT.ATTRIBUTE20
, PARTICIPANT.LOAN_PARTICIPANT_TYPE
, PARTY.PARTY_TYPE
, PARTICIPANT.CONTACT_PERS_PARTY_ID
, CON_PHONE.CONTACT_POINT_ID
, PARTICIPANT.CONTACT_REL_PARTY_ID
, PARTICIPANT.CREDIT_REQUEST_ID
FROM LNS_PARTICIPANTS PARTICIPANT
, HZ_PARTIES PARTY
, LNS_LOOKUPS PARTICIPANT_TYPE
, AR_LOOKUPS PARTY_TYPE
, FND_TERRITORIES_VL TERR
, HZ_PARTIES CON_PARTY
, HZ_CONTACT_POINTS CON_PHONE
WHERE PARTICIPANT.HZ_PARTY_ID = PARTY.PARTY_ID
AND (PARTICIPANT.END_DATE_ACTIVE IS NULL OR (SYSDATE BETWEEN PARTICIPANT.START_DATE_ACTIVE AND PARTICIPANT.END_DATE_ACTIVE) )
AND PARTY.COUNTRY = TERR.TERRITORY_CODE(+)
AND PARTICIPANT.LOAN_PARTICIPANT_TYPE = PARTICIPANT_TYPE.LOOKUP_CODE
AND PARTICIPANT_TYPE.LOOKUP_TYPE = 'LNS_PARTICIPANT_TYPE'
AND PARTY.PARTY_TYPE = PARTY_TYPE.LOOKUP_CODE
AND PARTY_TYPE.LOOKUP_TYPE = 'PARTY_TYPE'
AND CON_PARTY.PARTY_ID(+) = PARTICIPANT.CONTACT_PERS_PARTY_ID
AND CON_PHONE.OWNER_TABLE_NAME(+) = 'HZ_PARTIES'
AND CON_PHONE.OWNER_TABLE_ID(+) = PARTICIPANT.CONTACT_REL_PARTY_ID
AND CON_PHONE.PRIMARY_FLAG(+) = 'Y'
AND CON_PHONE.STATUS(+) = 'A'
AND CON_PHONE.CONTACT_POINT_TYPE(+) = 'PHONE'

Columns