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_COND_ASSIGNMENTS_VL

Object Details

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

View Type

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

MulitLingual view for condition assignment

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
ROW_ID	ROWID	(10)		Row Id of the table
COND_ASSIGNMENT_ID	NUMBER	(15)	Yes	Condition Assignment Identifier
LOAN_ID	NUMBER	(15)		Loan Identifier
CONDITION_ID	NUMBER	(15)	Yes	Condition Identifier
CONDITION_DESCRIPTION	VARCHAR2	(250)		Condition Description
CONDITION_MET_FLAG	VARCHAR2	(1)		Flag to indicate if condition has been met
MANDATORY_FLAG	VARCHAR2	(1)		Flag to indicate if condition must be met prior to submitting the loan for approval
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
FULFILLMENT_DATE	DATE			Date Condition is Fulfilled
FULFILLMENT_UPDATED_BY	NUMBER	(15)		User Id that updates the condition as fulfilled
START_DATE_ACTIVE	DATE			Start Date Active
END_DATE_ACTIVE	DATE			End Date Active
DISB_HEADER_ID	NUMBER	(15)		FK to LNS_DISB_HEADERS
DELETE_DISABLED_FLAG	VARCHAR2	(1)		Delete Disabled Flag
OWNER_OBJECT_ID	NUMBER			Object Owner Id
OWNER_TABLE	VARCHAR2	(100)		Owner Table

Query Text

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


SELECT ROW_ID
,      COND_ASSIGNMENT_ID
,      LOAN_ID
,      CONDITION_ID
,      CONDITION_DESCRIPTION
,      CONDITION_MET_FLAG
,      MANDATORY_FLAG
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      OBJECT_VERSION_NUMBER
,      FULFILLMENT_DATE
,      FULFILLMENT_UPDATED_BY
,      START_DATE_ACTIVE
,      END_DATE_ACTIVE
,      DISB_HEADER_ID
,      DELETE_DISABLED_FLAG
,      OWNER_OBJECT_ID
,      OWNER_TABLE
FROM APPS.LNS_COND_ASSIGNMENTS_VL;

Dependencies

[top of page]

APPS.LNS_COND_ASSIGNMENTS_VL references the following:

APPS: LNS_COND_ASSIGNMENTS; LNS_COND_ASSIGNMENTS_TL

APPS.LNS_COND_ASSIGNMENTS_VL is referenced by following:

APPS: LNS_COND_ASSIGNMENT_PUB - show dependent code; LNS_REP_UTILS - show dependent code