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_SUMMARY_V

Object Details

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

View Type

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

View for Loan Summary Information

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
LOAN_ID	NUMBER	(15)	Yes	Loan identifier
ORG_ID	NUMBER	(15)	Yes	Organization identifier (foreign key to HR_OPERATING_UNITS.ORGANIZATION_ID)
LOAN_NUMBER	VARCHAR2	(60)	Yes	Unique identification number for the loan
LOAN_STATUS	VARCHAR2	(80)	Yes	Loan Status
LOAN_CURRENCY_CODE	VARCHAR2	(15)	Yes	Loan Currency Code
LOAN_CURRENCY_MEANING	VARCHAR2	(80)	Yes	Loan Currency name
LOAN_TYPE	VARCHAR2	(80)		Loan Type
LOAN_CLASS	VARCHAR2	(80)	Yes	Loan Class
LOAN_SUBTYPE	VARCHAR2	(80)	Yes	Loan Subtype
LOAN_PRODUCT	VARCHAR2	(0)		Loan Product Name
LOAN_DESCRIPTION	VARCHAR2	(250)		Description of the loan
LOAN_PURPOSE	VARCHAR2	(80)	Yes	Loan Purpose
REQUESTED_AMOUNT	NUMBER		Yes	Requested Amount
FUNDED_AMOUNT	NUMBER			Funded Amount
CREATION_DATE	DATE		Yes	Creation Date
LOAN_APPLICATION_DATE	DATE		Yes	Loan Application Date
LOAN_APPROVAL_DATE	DATE			Loan Approval Date
LOAN_START_DATE	DATE		Yes	Loan Start Date
LOAN_MATURITY_DATE	DATE			Loan Maturity Date
LOAN_CLOSING_DATE	DATE			Loan Closing Date
CURRENT_INTEREST_RATE	NUMBER			Current Interest Rate Percentage
LOAN_TERM	NUMBER		Yes	Loan Term - length of the loan
LOAN_TERM_PERIOD	VARCHAR2	(80)	Yes	Loan Term Period - Months, Years, etc.
LOAN_AMORTIZED_TERM	NUMBER			Amortized Term - amortized length of the loan
LOAN_AMORTIZED_TERM_PERIOD	VARCHAR2	(80)	Yes	Amortized Term Period - Months, Years, etc.
REFERENCE_ID	NUMBER	(15)		When REFERENCE_TYPE='RECEIVABLE', this refers to the transaction identifier of the outstanding receivable that is used for creating this loan (foreign key to RA_CUSTOMER_TRX_ALL.CUSTOMER_TRX_ID).
REFERENCE_TYPE	VARCHAR2	(30)		Reference type. If the values is 'RECEIVABLE', it indicates whether this loan is created from an outstanding receivable.
REFERENCE_NUMBER	VARCHAR2	(60)		When REFERENCE_TYPE='RECEIVABLE', this refers to invoice number of the outstanding receivable that is used for creating this loan.
REFERENCE_DESCRIPTION	VARCHAR2	(250)		User entered Reference/Cost Report FYE
REFERENCE_TYPE_ID	NUMBER	(15)		The transaction type identifier that will be used for billing the loan (foreign key to RA_CUST_TRX_TYPES.CUST_TRX_TYPE_ID).
PRIMARY_BORROWER_ID	NUMBER	(15)		Party identifier for the primary borrower of this loan (foreign key to HZ_PARTIES.PARTY_ID). This value is denormalized from LNS_PARTICIPANTS.HZ_PARTY_ID
CUST_ACCOUNT_ID	NUMBER	(15)		Customer account identifier for the primary borrower of this loan (foreign key to HZ_CUST_ACCOUNTS.CUST_ACCOUNT_ID). This value is denormalized from LNS_PARTICIPANTS.CUST_ACCOUNT_ID
BILL_TO_ACCT_SITE_ID	NUMBER	(15)		Customer account billing site identifier for the primary borrower of the loan (foreign key to HZ_CUST_ACCT_SITES_ALL.CUST_ACCT_SITE_ID). This value is denormalized from LNS_PARTICIPANTS.BILL_TO_ACCT_SITE_ID
GL_DATE	DATE			GL Date
LOAN_AGENT_ID	NUMBER			Identifier for the user who is assigned to this loan (foreign key to JTF_RS_RESOURCE_EXTNS.RESOURCE_ID)
LOAN_AGENT_FIRST_NAME	VARCHAR2	(360)		Loan Assignee First Name
LOAN_AGENT_MIDDLE_NAME	VARCHAR2	(360)		Loan Assignee Middle Name
LOAN_AGENT_LAST_NAME	VARCHAR2	(360)		Loan Assignee Last Name
LOAN_AGENT_NAME	VARCHAR2	(360)		Loan Assignee Name
LOAN_END_DATE	DATE			Loan End Date
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
PRIMARY_CONTACT_REL_PARTY_ID	NUMBER	(15)		Primary Contact Relationship Party Identifier
PRIMARY_CONTACT_PERS_PARTY_ID	NUMBER	(15)		Primary Contact Person Party Identifier
PRIMARY_CONTACT_NAME	VARCHAR2	(360)		Primary Contact Person Name
COLLATERAL_PERCENT	NUMBER			Required Loan to Collateral Value ratio
CREDIT_REVIEW_FLAG	VARCHAR2	(1)		Credit Review Flag - indicates if credit review required for the loan
EXCHANGE_RATE_TYPE	VARCHAR2	(30)		Currency Exchange Rate Type
EXCHANGE_DATE	DATE			Currency Exchange Date
EXCHANGE_RATE	NUMBER			Currency Exchange Rate

Query Text

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


SELECT LOAN_ID
,      ORG_ID
,      LOAN_NUMBER
,      LOAN_STATUS
,      LOAN_CURRENCY_CODE
,      LOAN_CURRENCY_MEANING
,      LOAN_TYPE
,      LOAN_CLASS
,      LOAN_SUBTYPE
,      LOAN_PRODUCT
,      LOAN_DESCRIPTION
,      LOAN_PURPOSE
,      REQUESTED_AMOUNT
,      FUNDED_AMOUNT
,      CREATION_DATE
,      LOAN_APPLICATION_DATE
,      LOAN_APPROVAL_DATE
,      LOAN_START_DATE
,      LOAN_MATURITY_DATE
,      LOAN_CLOSING_DATE
,      CURRENT_INTEREST_RATE
,      LOAN_TERM
,      LOAN_TERM_PERIOD
,      LOAN_AMORTIZED_TERM
,      LOAN_AMORTIZED_TERM_PERIOD
,      REFERENCE_ID
,      REFERENCE_TYPE
,      REFERENCE_NUMBER
,      REFERENCE_DESCRIPTION
,      REFERENCE_TYPE_ID
,      PRIMARY_BORROWER_ID
,      CUST_ACCOUNT_ID
,      BILL_TO_ACCT_SITE_ID
,      GL_DATE
,      LOAN_AGENT_ID
,      LOAN_AGENT_FIRST_NAME
,      LOAN_AGENT_MIDDLE_NAME
,      LOAN_AGENT_LAST_NAME
,      LOAN_AGENT_NAME
,      LOAN_END_DATE
,      ATTRIBUTE_CATEGORY
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
,      ATTRIBUTE16
,      ATTRIBUTE17
,      ATTRIBUTE18
,      ATTRIBUTE19
,      ATTRIBUTE20
,      PRIMARY_CONTACT_REL_PARTY_ID
,      PRIMARY_CONTACT_PERS_PARTY_ID
,      PRIMARY_CONTACT_NAME
,      COLLATERAL_PERCENT
,      CREDIT_REVIEW_FLAG
,      EXCHANGE_RATE_TYPE
,      EXCHANGE_DATE
,      EXCHANGE_RATE
FROM APPS.LNS_LOAN_SUMMARY_V;

Dependencies

[top of page]

APPS.LNS_LOAN_SUMMARY_V references the following:

APPS: FND_CURRENCIES_VL; FND_GLOBAL - show dependent code; HZ_PARTIES; JTF_RS_RESOURCE_EXTNS; LNS_FIN_UTILS - show dependent code; LNS_LOAN_HEADERS; LNS_LOAN_TYPES; LNS_LOOKUPS

APPS.LNS_LOAN_SUMMARY_V is not referenced by any database object