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_INFO

Object Details

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

* Warning: Oracle Internal Use Only *

Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.

View Type

Internal

[View Source]

Columns

Name	Datatype	Length	Comments
LOAN_ID	NUMBER	(15)	Loan identifier
CUSTOMER_NAME	VARCHAR2	(360)	customer name
CUSTOMER_NUMBER	VARCHAR2	(30)	customer number
LOAN_NUMBER	VARCHAR2	(60)	loan number
LOAN_START_DATE	DATE		start date
FUNDED_AMOUNT	NUMBER		funded amount
LOAN_STATUS	VARCHAR2	(4000)	loan status
LOAN_CLASS	VARCHAR2	(4000)	loan class
LOAN_TYPE	VARCHAR2	(80)	loan type
DISB_HEADER_ID	NUMBER		Disbursement Header ID
DISBURSEMENT_STATUS	VARCHAR2	(4000)	Disbursement Status
DISBURSEMENT_NUMBER	NUMBER		Disbursement Number
DISBURSEMENT_REQUEST_DATE	DATE		Disbursement Request Date
LOAN_AMOUNT_ADJ_ID	NUMBER		Loan Amount Adjustment Id
LOAN_ADJUSTMENT_DESCRIPTION	VARCHAR2	(250)	Loan Adjustment Description
LOAN_LINE_ID	NUMBER		ERS Loan Additional Receivable Line Id
REFERENCE_DESCRIPTION	VARCHAR2	(250)	ERS Loan Additional Receivable Line Description

Query Text

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


SELECT LOAN_ID
,      CUSTOMER_NAME
,      CUSTOMER_NUMBER
,      LOAN_NUMBER
,      LOAN_START_DATE
,      FUNDED_AMOUNT
,      LOAN_STATUS
,      LOAN_CLASS
,      LOAN_TYPE
,      DISB_HEADER_ID
,      DISBURSEMENT_STATUS
,      DISBURSEMENT_NUMBER
,      DISBURSEMENT_REQUEST_DATE
,      LOAN_AMOUNT_ADJ_ID
,      LOAN_ADJUSTMENT_DESCRIPTION
,      LOAN_LINE_ID
,      REFERENCE_DESCRIPTION
FROM APPS.LNS_LOAN_INFO;

Dependencies

[top of page]

APPS.LNS_LOAN_INFO references the following:

APPS: HZ_CUST_ACCOUNTS; HZ_PARTIES; LNS_DISB_HEADERS; LNS_LOAN_AMOUNT_ADJS; LNS_LOAN_HEADERS_ALL; LNS_LOAN_LINES; LNS_LOAN_TYPES_VL; LNS_UTILITY_PUB - show dependent code

APPS.LNS_LOAN_INFO is not referenced by any database object