Search Results lns_cond_assignments

Overview

LNS_COND_ASSIGNMENTS is the Loan Condition Assignment table within the Oracle Loans (LNS) module of Oracle E-Business Suite, documented as VALID in release 12.1.1 and 12.2.2. The table records the association between a specific loan and the conditions that must be satisfied before, during, or after disbursement. Each row represents a single condition assigned to a single loan, carrying the fulfillment state, mandatory status, and effective dating for that assignment.

The object functions as an intersection entity: it links a loan to a reusable condition definition, so that the same condition can be applied to many loans while preserving an independent fulfillment outcome for each. In Data Vault terms, the mined foreign-key structure suggests a link classification, since the table's documented role is to resolve the many-to-many association between loans and conditions, with the fulfillment attributes behaving as link-level descriptive data. This classification is a heuristic modeling suggestion derived from the FK structure, not an ETRM-declared attribute.

Key Information Stored

The physical schema is owned by LNS and documents 20 columns. The surrogate primary key is COND_ASSIGNMENT_ID, enforced by LNS_COND_ASSIGNMENTS_PK and reinforced by the unique index LNS_COND_ASSIGNMENTS_U1 on the same column; COND_ASSIGNMENT_ID is therefore the only documented business-key candidate, and no natural composite business key is exposed in the metadata.

LOAN_ID — identifies the loan to which the condition is assigned; the principal reference back to the loan header.
CONDITION_ID — the condition definition applied to the loan; the second half of the link's business association.
CONDITION_DESCRIPTION — denormalized descriptive text for the assigned condition.
CONDITION_MET_FLAG — indicates whether the assigned condition has been satisfied.
MANDATORY_FLAG — marks the condition as required rather than optional for the loan.
FULFILLMENT_DATE — the date on which the condition was fulfilled.
FULFILLMENT_UPDATED_BY — the FND_USER who last updated fulfillment; also a documented foreign key.
START_DATE_ACTIVE and END_DATE_ACTIVE — effective-dating range for the assignment.
DISB_HEADER_ID — the disbursement header associated with the condition, where applicable.
DELETE_DISABLED_FLAG — controls whether the assignment may be deleted.
OWNER_OBJECT_ID and OWNER_TABLE — a polymorphic owner reference identifying the owning business object.
CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN, OBJECT_VERSION_NUMBER — standard who-columns and optimistic-locking version.

Common Use Cases and Queries

Condition fulfillment tracking is the dominant reporting use case. Lending operations query outstanding mandatory conditions per loan to determine disbursement readiness, and compliance functions review fulfillment dates and the user who closed each condition.

Conditions pending for a loan: select from LNS_COND_ASSIGNMENTS where LOAN_ID equals the target loan and CONDITION_MET_FLAG is not set.
Mandatory backlog: filter on MANDATORY_FLAG in combination with an unset CONDITION_MET_FLAG to isolate blocking items.
Effective-dated view: constrain by START_DATE_ACTIVE and END_DATE_ACTIVE to obtain currently active assignments.
Audit trail: join FULFILLMENT_UPDATED_BY to FND_USER to attribute fulfillment actions to named users.
Owner resolution: use OWNER_TABLE with OWNER_OBJECT_ID to route records back to the originating object.

Related Objects

LNS_CONDITIONS — referenced through COND_ASSIGNMENTS.CONDITION_ID; the condition definition master.
Loan header table — referenced through COND_ASSIGNMENTS.LOAN_ID; documented as a foreign relationship.
FND_USER — referenced through FULFILLMENT_UPDATED_BY for fulfillment attribution.
LNS_COND_ASSIGNMENTS_PK / LNS_COND_ASSIGNMENTS_U1 — primary key constraint and unique index on COND_ASSIGNMENT_ID.
Disbursement header objects — associated via DISB_HEADER_ID.

Table: LNS_COND_ASSIGNMENTS 12.1.1
owner:LNS, object_type:TABLE, fnd_design_data:LNS.LNS_COND_ASSIGNMENTS, object_name:LNS_COND_ASSIGNMENTS, status:VALID, product: LNS - Loans , description: Loan Condition Assignment Table , implementation_dba_data: LNS.LNS_COND_ASSIGNMENTS ,
Table: LNS_COND_ASSIGNMENTS 12.2.2
owner:LNS, object_type:TABLE, fnd_design_data:LNS.LNS_COND_ASSIGNMENTS, object_name:LNS_COND_ASSIGNMENTS, status:VALID, product: LNS - Loans , description: Loan Condition Assignment Table , implementation_dba_data: LNS.LNS_COND_ASSIGNMENTS ,
APPS.LNS_SAMPLE_CUSTOM_CONDS SQL Statements 12.2.2
VIEW: LNS.LNS_COND_ASSIGNMENTS# 12.2.2
owner:LNS, object_type:VIEW, object_name:LNS_COND_ASSIGNMENTS#, status:VALID,
SYNONYM: APPS.LNS_COND_ASSIGNMENTS 12.1.1
owner:APPS, object_type:SYNONYM, object_name:LNS_COND_ASSIGNMENTS, status:VALID,
SYNONYM: APPS.LNS_COND_ASSIGNMENTS 12.2.2
owner:APPS, object_type:SYNONYM, object_name:LNS_COND_ASSIGNMENTS, status:VALID,
APPS.LNS_COND_ASSIGNMENT_PUB SQL Statements 12.2.2
APPS.LNS_COND_ASSIGNMENTS_PKG SQL Statements 12.2.2
VIEW: APPS.LNS_COND_ASSIGNMENTS_VL 12.1.1
VIEW: APPS.LNS_COND_ASSIGNMENTS_VL 12.2.2
VIEW: LNS.LNS_COND_ASSIGNMENTS# 12.2.2
APPS.LNS_COND_ASSIGNMENT_PUB SQL Statements 12.1.1
APPS.LNS_COND_ASSIGNMENTS_PKG SQL Statements 12.1.1
TABLE: LNS.LNS_COND_ASSIGNMENTS 12.1.1
owner:LNS, object_type:TABLE, fnd_design_data:LNS.LNS_COND_ASSIGNMENTS, object_name:LNS_COND_ASSIGNMENTS, status:VALID,
TABLE: LNS.LNS_COND_ASSIGNMENTS 12.2.2
owner:LNS, object_type:TABLE, fnd_design_data:LNS.LNS_COND_ASSIGNMENTS, object_name:LNS_COND_ASSIGNMENTS, status:VALID,
12.2.2 FND Design Data 12.2.2
Table: LNS_CONDITIONS 12.1.1
owner:LNS, object_type:TABLE, fnd_design_data:LNS.LNS_CONDITIONS, object_name:LNS_CONDITIONS, status:VALID, product: LNS - Loans , description: Loan Conditions Table , implementation_dba_data: LNS.LNS_CONDITIONS ,
Table: LNS_CONDITIONS 12.2.2
owner:LNS, object_type:TABLE, fnd_design_data:LNS.LNS_CONDITIONS, object_name:LNS_CONDITIONS, status:VALID, product: LNS - Loans , description: Loan Conditions Table , implementation_dba_data: LNS.LNS_CONDITIONS ,
12.2.2 DBA Data 12.2.2
12.2.2 DBA Data 12.2.2
12.2.2 DBA Data 12.2.2
PACKAGE BODY: APPS.LNS_COND_ASSIGNMENTS_PKG 12.2.2
owner:APPS, object_type:PACKAGE BODY, object_name:LNS_COND_ASSIGNMENTS_PKG, status:VALID,
PACKAGE BODY: APPS.LNS_COND_ASSIGNMENTS_PKG 12.2.2
PACKAGE BODY: APPS.LNS_COND_ASSIGNMENT_PUB 12.1.1
owner:APPS, object_type:PACKAGE BODY, object_name:LNS_COND_ASSIGNMENT_PUB, status:VALID,
12.1.1 DBA Data 12.1.1
PACKAGE BODY: APPS.LNS_SUBMIT_FOR_APPROVAL_PUB 12.1.1
owner:APPS, object_type:PACKAGE BODY, object_name:LNS_SUBMIT_FOR_APPROVAL_PUB, status:VALID,
PACKAGE BODY: APPS.LNS_COND_ASSIGNMENTS_PKG 12.1.1
12.1.1 FND Design Data 12.1.1
12.1.1 DBA Data 12.1.1
12.2.2 DBA Data 12.2.2
PACKAGE BODY: APPS.LNS_SAMPLE_CUSTOM_CONDS 12.2.2
owner:APPS, object_type:PACKAGE BODY, object_name:LNS_SAMPLE_CUSTOM_CONDS, status:VALID,
PACKAGE BODY: APPS.LNS_COND_ASSIGNMENTS_PKG 12.1.1
owner:APPS, object_type:PACKAGE BODY, object_name:LNS_COND_ASSIGNMENTS_PKG, status:VALID,
12.1.1 DBA Data 12.1.1
PACKAGE BODY: APPS.LNS_SUBMIT_FOR_APPROVAL_PUB 12.2.2
owner:APPS, object_type:PACKAGE BODY, object_name:LNS_SUBMIT_FOR_APPROVAL_PUB, status:VALID,
PACKAGE BODY: APPS.LNS_COND_ASSIGNMENT_PUB 12.2.2
owner:APPS, object_type:PACKAGE BODY, object_name:LNS_COND_ASSIGNMENT_PUB, status:VALID,
TABLE: LNS.LNS_COND_ASSIGNMENTS_TL 12.2.2
owner:LNS, object_type:TABLE, object_name:LNS_COND_ASSIGNMENTS_TL, status:VALID,
12.2.2 DBA Data 12.2.2
PACKAGE BODY: APPS.LNS_APPROVAL_ACTION_PUB 12.2.2
owner:APPS, object_type:PACKAGE BODY, object_name:LNS_APPROVAL_ACTION_PUB, status:VALID,
PACKAGE BODY: APPS.LNS_FUNDING_PUB 12.1.1
owner:APPS, object_type:PACKAGE BODY, object_name:LNS_FUNDING_PUB, status:VALID,
TABLE: LNS.LNS_COND_ASSIGNMENTS_TL 12.1.1
owner:LNS, object_type:TABLE, object_name:LNS_COND_ASSIGNMENTS_TL, status:VALID,
PACKAGE BODY: APPS.LNS_COND_ASSIGNMENT_PUB 12.1.1
VIEW: APPS.LNS_COND_ASSIGNMENTS_VL 12.1.1
owner:APPS, object_type:VIEW, object_name:LNS_COND_ASSIGNMENTS_VL, status:VALID,
PACKAGE BODY: APPS.LNS_FUNDING_PUB 12.2.2
owner:APPS, object_type:PACKAGE BODY, object_name:LNS_FUNDING_PUB, status:VALID,
VIEW: APPS.LNS_COND_ASSIGNMENTS_VL 12.2.2
owner:APPS, object_type:VIEW, object_name:LNS_COND_ASSIGNMENTS_VL, status:VALID,
PACKAGE BODY: APPS.LNS_COND_ASSIGNMENT_PUB 12.2.2
APPS.LNS_SUBMIT_FOR_APPROVAL_PUB SQL Statements 12.1.1
APPS.LNS_APPROVAL_ACTION_PUB SQL Statements 12.2.2
APPS.LNS_SUBMIT_FOR_APPROVAL_PUB SQL Statements 12.2.2
PACKAGE BODY: APPS.LNS_SAMPLE_CUSTOM_CONDS 12.2.2
Table: FND_USER 12.2.2
owner:APPLSYS, object_type:TABLE, fnd_design_data:FND.FND_USER, object_name:FND_USER, status:VALID, product: FND - Application Object Library , description: Application users , implementation_dba_data: APPLSYS.FND_USER ,