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_DETAILS_EXT_V

Object Details

Object Name:	LNS_LOAN_DETAILS_EXT_V
Object Type:	VIEW
Owner:	APPS
FND Design Data:	LNS.LNS_LOAN_DETAILS_EXT_V
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	Mandatory	Comments
EVENT_ID	NUMBER	(15)	Yes	Event ID
LEDGER_ID	NUMBER	(15)	Yes	Ledger ID
LINE_NUMBER	NUMBER	(15)	Yes	Extract Line
DISTRIBUTION_ID	NUMBER	(15)	Yes	Loans Distribution ID
LOAN_ID	NUMBER	(15)	Yes	Loan ID
LINE_TYPE	VARCHAR2	(30)	Yes	Line Type
ACCOUNT_NAME	VARCHAR2	(30)	Yes	Account Name
CODE_COMBINATION_ID	NUMBER	(15)	Yes	CC_ID
ACCOUNT_TYPE	VARCHAR2	(30)	Yes	Account Type
DISTRIBUTION_PERCENT	NUMBER		Yes	Distribution Percent
DISTRIBUTION_AMOUNT	NUMBER			Distribution Amount
START_DATE_ACTIVE	DATE			Start Date
END_DATE_ACTIVE	DATE			End Date
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
OBJECT_VERSION_NUMBER	NUMBER		Yes	Standard Who Column
ATTRIBUTE_CATEGORY	VARCHAR2	(30)		Flexfield
ATTRIBUTE1	VARCHAR2	(150)		Flexfield
ATTRIBUTE2	VARCHAR2	(150)		Flexfield
ATTRIBUTE3	VARCHAR2	(150)		Flexfield
ATTRIBUTE4	VARCHAR2	(150)		Flexfield
ATTRIBUTE5	VARCHAR2	(150)		Flexfield
ATTRIBUTE6	VARCHAR2	(150)		Flexfield
ATTRIBUTE7	VARCHAR2	(150)		Flexfield
ATTRIBUTE8	VARCHAR2	(150)		Flexfield
ATTRIBUTE9	VARCHAR2	(150)		Flexfield
ATTRIBUTE10	VARCHAR2	(150)		Flexfield
ATTRIBUTE11	VARCHAR2	(150)		Flexfield
ATTRIBUTE12	VARCHAR2	(150)		Flexfield
ATTRIBUTE13	VARCHAR2	(150)		Flexfield
ATTRIBUTE14	VARCHAR2	(150)		Flexfield
ATTRIBUTE15	VARCHAR2	(150)		Flexfield
ATTRIBUTE16	VARCHAR2	(150)		Flexfield
ATTRIBUTE17	VARCHAR2	(150)		Flexfield
ATTRIBUTE18	VARCHAR2	(150)		Flexfield
ATTRIBUTE19	VARCHAR2	(150)		Flexfield
ATTRIBUTE20	VARCHAR2	(150)		Flexfield
DISTRIBUTION_TYPE	VARCHAR2	(30)		Distribution Type
LAST_UPDATE_LOGIN	NUMBER	(15)		Standard Who Column
USSGL_TRANSACTION_CODE	VARCHAR2	(30)		Obsoleted
FEE_ID	NUMBER	(15)		Fee ID
DISB_HEADER_ID	NUMBER			Disbursement Header ID
DISBURSEMENT_STATUS	VARCHAR2	(30)		Disbursement Status
DISBURSEMENT_AMOUNT	NUMBER			Disbursement Amount
DISBURSEMENT_NUMBER	NUMBER			Disbursement NUmber
EVENT_TYPE	VARCHAR2	(30)	Yes	Event Type
BALANCING_SEGMENT_VALUE	VARCHAR2	(25)		BSV
DERIVED_PROGRAM_ACCOUNT_BSV	VARCHAR2	(25)		Derived BSV
LOAN_AMOUNT_ADJ_ID	NUMBER			Loan Amount Adjustment Id
LOAN_ADJUSTMENT_DESCRIPTION	VARCHAR2	(250)		Adjustment Description
LOAN_LINE_ID	NUMBER			ERS Loan Additional Receivable Line Id
ORIG_ENCUM_DIST_ID	NUMBER			Original Encumbrance Distribution Id used to refer the Loan Approval Distribution
ORIG_ENCUM_DIST_AMT	NUMBER			Original Encumbrance Distribution Amount used to refer the Loan Approval Distribution Amount
ORIG_ENCUM_SYS_TRX_ID	NUMBER			Original System Transaction Identifier whose value is -1

Query Text

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


SELECT EVENT_ID
,      LEDGER_ID
,      LINE_NUMBER
,      DISTRIBUTION_ID
,      LOAN_ID
,      LINE_TYPE
,      ACCOUNT_NAME
,      CODE_COMBINATION_ID
,      ACCOUNT_TYPE
,      DISTRIBUTION_PERCENT
,      DISTRIBUTION_AMOUNT
,      START_DATE_ACTIVE
,      END_DATE_ACTIVE
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      OBJECT_VERSION_NUMBER
,      ATTRIBUTE_CATEGORY
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
,      ATTRIBUTE16
,      ATTRIBUTE17
,      ATTRIBUTE18
,      ATTRIBUTE19
,      ATTRIBUTE20
,      DISTRIBUTION_TYPE
,      LAST_UPDATE_LOGIN
,      USSGL_TRANSACTION_CODE
,      FEE_ID
,      DISB_HEADER_ID
,      DISBURSEMENT_STATUS
,      DISBURSEMENT_AMOUNT
,      DISBURSEMENT_NUMBER
,      EVENT_TYPE
,      BALANCING_SEGMENT_VALUE
,      DERIVED_PROGRAM_ACCOUNT_BSV
,      LOAN_AMOUNT_ADJ_ID
,      LOAN_ADJUSTMENT_DESCRIPTION
,      LOAN_LINE_ID
,      ORIG_ENCUM_DIST_ID
,      ORIG_ENCUM_DIST_AMT
,      ORIG_ENCUM_SYS_TRX_ID
FROM APPS.LNS_LOAN_DETAILS_EXT_V;

Dependencies

[top of page]

APPS.LNS_LOAN_DETAILS_EXT_V references the following:

APPS: FV_FUND_PARAMETERS; GL_CODE_COMBINATIONS; LNS_DISB_HEADERS; LNS_DISTRIBUTIONS; LNS_DISTRIBUTIONS_PUB - show dependent code; LNS_LOAN_AMOUNT_ADJS; LNS_LOAN_HEADERS_ALL; LNS_UTILITY_PUB - show dependent code; XLA_EVENTS; XLA_TRANSACTION_ENTITIES

APPS.LNS_LOAN_DETAILS_EXT_V is referenced by following:

APPS: XLA_00206_AAD_S_000003_PKG - show dependent code; XLA_00206_AAD_S_000004_BC_PKG - show dependent code; XLA_00206_AAD_S_000004_PKG - show dependent code