eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

DBA Data [Home] [Help] [Dependency Information]

VIEW: APPS.LNS_LOAN_PARTICIPANTS_V

Object Details

Object Name:	LNS_LOAN_PARTICIPANTS_V
Object Type:	VIEW
Owner:	APPS
FND Design Data:	LNS.LNS_LOAN_PARTICIPANTS_V
Subobject Name:
Status:	VALID

View Type

A public view which may be useful for custom reporting or other data
requirements.

View for Loan Participants Information

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
LOAN_ID	NUMBER	(15)	Yes	Loan identifier
PARTICIPANT_NAME	VARCHAR2	(360)	Yes	Participant Party Name
PARTICIPANT_TYPE	VARCHAR2	(80)	Yes	Participant Type code
PARTICIPANT_PARTY_TYPE	VARCHAR2	(80)	Yes	Participant Party Type code - ORGANIZATION or PERSON.
PARTICIPANT_ADDRESS	VARCHAR2	(504)		Concatenation of the primary address fields for the participant
PARTICIPANT_CONTACT	VARCHAR2	(360)		Primary contact person name
PARTICIPANT_CONTACT_PHONE	VARCHAR2	(60)		Primary telephone number for the primary contact peson
HZ_PARTY_ID	NUMBER	(15)	Yes	Party identifier for the participant (foreign key to HZ_PARTIES.PARTY_ID)
PARTICIPANT_ID	NUMBER	(15)	Yes	Participant identifier
CUST_ACCOUNT_ID	NUMBER	(15)		Customer Account identifier for the participant (foreign key to HZ_CUST_ACCOUNTS.CUST_ACCOUNT_ID)
BILL_TO_ACCT_SITE_ID	NUMBER	(15)		Customer account billing site identifier for the participant (foreign key to HZ_CUST_ACCT_SITES_ALL.CUST_ACCT_SITE_ID).
START_DATE_ACTIVE	DATE			Start Date Active
END_DATE_ACTIVE	DATE			End Date Active. The date until which the participant is active on the loan.
ATTRIBUTE_CATEGORY	VARCHAR2	(30)		Descriptive flexfield structure definition column
ATTRIBUTE1	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE2	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE3	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE4	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE5	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE6	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE7	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE8	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE9	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE10	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE11	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE12	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE13	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE14	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE15	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE16	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE17	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE18	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE19	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE20	VARCHAR2	(150)		Descriptive flexfield segment
PARTICIPANT_TYPE_CODE	VARCHAR2	(30)		Participant Type code
PARTY_TYPE_CODE	VARCHAR2	(30)	Yes	Participant Party Type Code
CONTACT_PERSON_PARTY_ID	NUMBER	(15)		Contact Person Party identifier
CONTACT_PHONE_ID	NUMBER	(15)		Contact Person Phone identifier
CONTACT_RELATIONSHIP_PARTY_ID	NUMBER	(15)		Contact Relationship Party identifier
CREDIT_REQUEST_ID	NUMBER	(15)		Credit Request identifier

Query Text

Cut, paste (and edit) the following text to query this object:


SELECT LOAN_ID
,      PARTICIPANT_NAME
,      PARTICIPANT_TYPE
,      PARTICIPANT_PARTY_TYPE
,      PARTICIPANT_ADDRESS
,      PARTICIPANT_CONTACT
,      PARTICIPANT_CONTACT_PHONE
,      HZ_PARTY_ID
,      PARTICIPANT_ID
,      CUST_ACCOUNT_ID
,      BILL_TO_ACCT_SITE_ID
,      START_DATE_ACTIVE
,      END_DATE_ACTIVE
,      ATTRIBUTE_CATEGORY
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
,      ATTRIBUTE16
,      ATTRIBUTE17
,      ATTRIBUTE18
,      ATTRIBUTE19
,      ATTRIBUTE20
,      PARTICIPANT_TYPE_CODE
,      PARTY_TYPE_CODE
,      CONTACT_PERSON_PARTY_ID
,      CONTACT_PHONE_ID
,      CONTACT_RELATIONSHIP_PARTY_ID
,      CREDIT_REQUEST_ID
FROM APPS.LNS_LOAN_PARTICIPANTS_V;

Dependencies

[top of page]

APPS.LNS_LOAN_PARTICIPANTS_V references the following:

APPS: AR_LOOKUPS; FND_GLOBAL - show dependent code; FND_TERRITORIES_VL; HZ_CONTACT_POINTS; HZ_PARTIES; LNS_LOOKUPS; LNS_PARTICIPANTS

APPS.LNS_LOAN_PARTICIPANTS_V is referenced by following:

APPS: AR_CMGT_AGING - show dependent code; AR_CMGT_DATA_POINTS_PKG - show dependent code