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]

TABLE: LNS.LNS_COND_ASSIGNMENTS

Object Details

Object Name:	LNS_COND_ASSIGNMENTS
Object Type:	TABLE
Owner:	LNS
FND Design Data:	LNS.LNS_COND_ASSIGNMENTS
Subobject Name:
Status:	VALID

LNS_COND_ASSIGNMENTS stores the assignments of conditions to existing loans. It allows the user to override the default condition description with more descriptive text, or change the mandatory property of the condition at the time of assignment. The table also tracks when the condition is fulfilled.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
LNS_COND_ASSIGNMENTS_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	COND_ASSIGNMENT_ID
LNS_COND_ASSIGNMENTS_N1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	LOAN_ID
LNS_COND_ASSIGNMENTS_N2	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	DISB_HEADER_ID
LNS_COND_ASSIGNMENTS_U2	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	CONDITION_ID

Columns

Name	Datatype	Length	Mandatory	Comments
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

Query Text

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


SELECT 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
FROM LNS.LNS_COND_ASSIGNMENTS;

Dependencies

[top of page]

LNS.LNS_COND_ASSIGNMENTS does not reference any database object

LNS.LNS_COND_ASSIGNMENTS is referenced by following:

APPS: LNS_COND_ASSIGNMENTS