VIEW: APPS.LNS_COND_ASSIGNMENTS_VL

Source

View Text - Preformatted

SELECT B.ROWID ROW_ID ,B.COND_ASSIGNMENT_ID ,B.LOAN_ID ,B.CONDITION_ID ,T.CONDITION_DESCRIPTION ,B.CONDITION_MET_FLAG ,B.MANDATORY_FLAG ,B.CREATED_BY ,B.CREATION_DATE ,B.LAST_UPDATED_BY ,B.LAST_UPDATE_DATE ,B.LAST_UPDATE_LOGIN ,B.OBJECT_VERSION_NUMBER ,B.FULFILLMENT_DATE ,B.FULFILLMENT_UPDATED_BY ,B.START_DATE_ACTIVE ,B.END_DATE_ACTIVE ,B.DISB_HEADER_ID ,B.DELETE_DISABLED_FLAG, B.OWNER_OBJECT_ID, B.OWNER_TABLE FROM LNS_COND_ASSIGNMENTS B, LNS_COND_ASSIGNMENTS_TL T WHERE B.COND_ASSIGNMENT_ID = T.COND_ASSIGNMENT_ID and T.LANGUAGE = userenv('LANG')

View Text - HTML Formatted

SELECT B.ROWID ROW_ID
, B.COND_ASSIGNMENT_ID
, B.LOAN_ID
, B.CONDITION_ID
, T.CONDITION_DESCRIPTION
, B.CONDITION_MET_FLAG
, B.MANDATORY_FLAG
, B.CREATED_BY
, B.CREATION_DATE
, B.LAST_UPDATED_BY
, B.LAST_UPDATE_DATE
, B.LAST_UPDATE_LOGIN
, B.OBJECT_VERSION_NUMBER
, B.FULFILLMENT_DATE
, B.FULFILLMENT_UPDATED_BY
, B.START_DATE_ACTIVE
, B.END_DATE_ACTIVE
, B.DISB_HEADER_ID
, B.DELETE_DISABLED_FLAG
, B.OWNER_OBJECT_ID
, B.OWNER_TABLE
FROM LNS_COND_ASSIGNMENTS B
, LNS_COND_ASSIGNMENTS_TL T
WHERE B.COND_ASSIGNMENT_ID = T.COND_ASSIGNMENT_ID
AND T.LANGUAGE = USERENV('LANG')