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.

VIEW: LNS.LNS_COND_ASSIGNMENTS#

Source

View Text - Preformatted


select COND_ASSIGNMENT_ID COND_ASSIGNMENT_ID, LOAN_ID LOAN_ID, CONDITION_ID CONDITION_ID, CONDITION_DESCRIPTION CONDITION_DESCRIPTION, CONDITION_MET_FLAG CONDITION_MET_FLAG, MANDATORY_FLAG MANDATORY_FLAG, CREATED_BY CREATED_BY, CREATION_DATE CREATION_DATE, LAST_UPDATED_BY LAST_UPDATED_BY, LAST_UPDATE_DATE LAST_UPDATE_DATE, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER, FULFILLMENT_DATE FULFILLMENT_DATE, FULFILLMENT_UPDATED_BY FULFILLMENT_UPDATED_BY, START_DATE_ACTIVE START_DATE_ACTIVE, END_DATE_ACTIVE END_DATE_ACTIVE, DISB_HEADER_ID DISB_HEADER_ID, DELETE_DISABLED_FLAG DELETE_DISABLED_FLAG, OWNER_OBJECT_ID OWNER_OBJECT_ID, OWNER_TABLE OWNER_TABLE from "LNS"."LNS_COND_ASSIGNMENTS"

View Text - HTML Formatted

SELECT COND_ASSIGNMENT_ID COND_ASSIGNMENT_ID
, LOAN_ID LOAN_ID
, CONDITION_ID CONDITION_ID
, CONDITION_DESCRIPTION CONDITION_DESCRIPTION
, CONDITION_MET_FLAG CONDITION_MET_FLAG
, MANDATORY_FLAG MANDATORY_FLAG
, CREATED_BY CREATED_BY
, CREATION_DATE CREATION_DATE
, LAST_UPDATED_BY LAST_UPDATED_BY
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER
, FULFILLMENT_DATE FULFILLMENT_DATE
, FULFILLMENT_UPDATED_BY FULFILLMENT_UPDATED_BY
, START_DATE_ACTIVE START_DATE_ACTIVE
, END_DATE_ACTIVE END_DATE_ACTIVE
, DISB_HEADER_ID DISB_HEADER_ID
, DELETE_DISABLED_FLAG DELETE_DISABLED_FLAG
, OWNER_OBJECT_ID OWNER_OBJECT_ID
, OWNER_TABLE OWNER_TABLE
FROM "LNS"."LNS_COND_ASSIGNMENTS"