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_TYPES_VL

Object Details

Object Name:	LNS_LOAN_TYPES_VL
Object Type:	VIEW
Owner:	APPS
Subobject Name:
Status:	VALID

View Type

MultiLingual view (a language resolved view of the data.)

Loan Products Translation View for table LNS_LOAN_TYPES

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
ROW_ID	ROWID	(10)		Row id of the table
LOAN_TYPE_ID	NUMBER	(15)	Yes	Identifies the Loan Type
LOAN_TYPE_NAME	VARCHAR2	(80)	Yes	Identifies the Loan Type Name
LOAN_TYPE_DESC	VARCHAR2	(250)		Identifies the Loan Type Description
LOAN_CLASS_CODE	VARCHAR2	(30)	Yes	Identifies the Loan Class Code
START_DATE_ACTIVE	DATE			The starting activation date of the loanType
END_DATE_ACTIVE	DATE			The ending activation date of the laonType
STATUS	VARCHAR2	(30)		The status of the loanType
CALCULATION_METHOD	VARCHAR2	(30)		The interest calculation method for the inherited loanproducts
DAY_COUNT_METHOD	VARCHAR2	(30)		The dayCountMethod used in loans
MULTIPLE_FUNDING_FLAG	VARCHAR2	(1)		Represents the Multiple disbursement of the inherited loan
OPEN_TO_TERM_FLAG	VARCHAR2	(1)		Identifies whether the loan is converted permanent
CREDIT_REVIEW_FLAG	VARCHAR2	(1)		Provides the ability to check the credit rating of the borrower if this value is Y
CREATED_BY	NUMBER	(15)	Yes	Standard Who Column
CREATION_DATE	DATE		Yes	Standard Who Column
LAST_UPDATED_BY	NUMBER	(15)	Yes	Standard Who Column
LAST_UPDATE_DATE	DATE		Yes	Standard Who Column
LAST_UPDATE_LOGIN	NUMBER	(15)		Standard Who Column
OBJECT_VERSION_NUMBER	NUMBER		Yes	Object Version Number
LOAN_TYPE_CODE	VARCHAR2	(30)		The Loan type Code
PAYMENT_APPLICATION_ORDER	VARCHAR2	(30)		Represents the order of the payment done on invoices
PMT_APPL_ORDER_SCOPE	VARCHAR2	(30)		Scope of the Payment applicaiton order

Query Text

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


SELECT ROW_ID
,      LOAN_TYPE_ID
,      LOAN_TYPE_NAME
,      LOAN_TYPE_DESC
,      LOAN_CLASS_CODE
,      START_DATE_ACTIVE
,      END_DATE_ACTIVE
,      STATUS
,      CALCULATION_METHOD
,      DAY_COUNT_METHOD
,      MULTIPLE_FUNDING_FLAG
,      OPEN_TO_TERM_FLAG
,      CREDIT_REVIEW_FLAG
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      OBJECT_VERSION_NUMBER
,      LOAN_TYPE_CODE
,      PAYMENT_APPLICATION_ORDER
,      PMT_APPL_ORDER_SCOPE
FROM APPS.LNS_LOAN_TYPES_VL;

Dependencies

[top of page]

APPS.LNS_LOAN_TYPES_VL references the following:

APPS: LNS_LOAN_TYPES; LNS_LOAN_TYPES_TL

APPS.LNS_LOAN_TYPES_VL is referenced by following:

APPS: LNS_BILLING_BATCH_PUB - show dependent code; LNS_LOAN_HEADERS_EXT_V; LNS_LOAN_INFO; LNS_REP_UTILS - show dependent code; LNS_WORK_FLOW - show dependent code