View: ZOKL_CSE_LITIGATIONS_V

View Text

SELECT CLNB.ROWID ROW_ID
, CLNB.ID ID
, CLNB.OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER
, CLNT.SFWT_FLAG SFWT_FLAG
, CLNB.CAC_ID CAC_ID
, CLNB.ACCELARATION_LETTER_SENT_DATE ACCELARATION_LETTER_SENT_DATE
, CLNB.SEQUENCE_NUMBER SEQUENCE_NUMBER
, CLNB.ALL_PARITES_CONTACTED_YN ALL_PARITES_CONTACTED_YN
, CLNT.COMMENTS COMMENTS
, CLNB.BANKS_CONTACTED_YN BANKS_CONTACTED_YN
, CLNB.LOC_REVIEW_YN LOC_REVIEW_YN
, CLNB.CD_REVIEW_YN CD_REVIEW_YN
, CLNB.RESPOSSESION_CONSENT_DATE RESPOSSESION_CONSENT_DATE
, CLNB.CREDIT_REPORT_ORDERED_DATE CREDIT_REPORT_ORDERED_DATE
, CLNB.INVESTOR_ASSISTANCE_REQD_DATE INVESTOR_ASSISTANCE_REQD_DATE
, CLNB.VENDOR_ASSISTANCE_REQD_DATE VENDOR_ASSISTANCE_REQD_DATE
, CLNB.CUSTOMER_DEF_LETT_SENT_DATE CUSTOMER_DEF_LETT_SENT_DATE
, CLNB.VENDOR_ACCELATN_NOTICE_DATE VENDOR_ACCELATN_NOTICE_DATE
, CLNB.GUARANTOR_DEF_LETT_SENT_DATE GUARANTOR_DEF_LETT_SENT_DATE
, CLNB.CUSTOMER_ESCALATION_YN CUSTOMER_ESCALATION_YN
, CLNB.DIRECT_SUIT_LITIGATION_YN DIRECT_SUIT_LITIGATION_YN
, CLNT.EXTENSION_COMMENT EXTENSION_COMMENT
, CLNB.EXTENSION_DATE EXTENSION_DATE
, CLNB.REPOSSESION_REQUEST_DATE REPOSSESION_REQUEST_DATE
, CLNB.LEGAL_AVAILABILITY_OF_EQIPMENT LEGAL_AVAILABILITY_OF_EQIPMENT
, CLNB.LMV_REQUESTED_DATE LMV_REQUESTED_DATE
, CLNB.OLV_REQUESTED_DATE OLV_REQUESTED_DATE
, CLNB.MULTIPLE_CONTRACTS_INVOLVED_YN MULTIPLE_CONTRACTS_INVOLVED_YN
, CLNB.ASSIGNMENT_NOTICE_SENT_DATE ASSIGNMENT_NOTICE_SENT_DATE
, CLNB.TERMINATION_NOTICE_SENT_DATE TERMINATION_NOTICE_SENT_DATE
, CLNB.PAYMENT_HISTORY_SENT_YN PAYMENT_HISTORY_SENT_YN
, CLNT.PAYMENT_PLAN_COMMENTS PAYMENT_PLAN_COMMENTS
, CLNB.PAYMENT_PLAN_DATE PAYMENT_PLAN_DATE
, CLNT.RESTRUCTURE_COMMENTS RESTRUCTURE_COMMENTS
, CLNB.RESTRUCTURE_DATE RESTRUCTURE_DATE
, CLNB.RECOURSE_REVIEW_YN RECOURSE_REVIEW_YN
, CLNB.EQUIPMENT_SELL_CONF_DATE EQUIPMENT_SELL_CONF_DATE
, CLNB.SERVICE_PLACED_ON_HOLD_DATE SERVICE_PLACED_ON_HOLD_DATE
, CLNT.SETTLEMNT_COMMENTS SETTLEMNT_COMMENTS
, CLNB.SETTLEMENT_DATE SETTLEMENT_DATE
, CLNB.COLLECTION_SYNOPSIS_DOC_YN COLLECTION_SYNOPSIS_DOC_YN
, CLNT.TRANSFER_COMMENTS TRANSFER_COMMENTS
, CLNB.TRANSFER_DATE TRANSFER_DATE
, CLNB.VENDOR_PROGRAM_SATISFIED_YN VENDOR_PROGRAM_SATISFIED_YN
, CLNB.WILL_LESSEE_RELEASE_EQUIP_YN WILL_LESSEE_RELEASE_EQUIP_YN
, CLNB.ATTRIBUTE_CATEGORY ATTRIBUTE_CATEGORY
, CLNB.ATTRIBUTE1 ATTRIBUTE1
, CLNB.ATTRIBUTE2 ATTRIBUTE2
, CLNB.ATTRIBUTE3 ATTRIBUTE3
, CLNB.ATTRIBUTE4 ATTRIBUTE4
, CLNB.ATTRIBUTE5 ATTRIBUTE5
, CLNB.ATTRIBUTE6 ATTRIBUTE6
, CLNB.ATTRIBUTE7 ATTRIBUTE7
, CLNB.ATTRIBUTE8 ATTRIBUTE8
, CLNB.ATTRIBUTE9 ATTRIBUTE9
, CLNB.ATTRIBUTE10 ATTRIBUTE10
, CLNB.ATTRIBUTE11 ATTRIBUTE11
, CLNB.ATTRIBUTE12 ATTRIBUTE12
, CLNB.ATTRIBUTE13 ATTRIBUTE13
, CLNB.ATTRIBUTE14 ATTRIBUTE14
, CLNB.ATTRIBUTE15 ATTRIBUTE15
, CLNB.DRC_CODE DRC_CODE
, CLNB.VVN_CODE VVN_CODE
, CLNB.ORG_ID ORG_ID
, CLNB.REQUEST_ID REQUEST_ID
, CLNB.PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID
, CLNB.PROGRAM_ID PROGRAM_ID
, CLNB.PROGRAM_UPDATE_DATE PROGRAM_UPDATE_DATE
, CLNB.CREATED_BY CREATED_BY
, CLNB.CREATION_DATE CREATION_DATE
, CLNB.LAST_UPDATED_BY LAST_UPDATED_BY
, CLNB.LAST_UPDATE_DATE LAST_UPDATE_DATE
, CLNB.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
FROM ZOKL_CSE_LITIGATIONS_B CLNB
, ZOKL_CSE_LITIGATIONS_TL CLNT
WHERE CLNB.ID = CLNT.ID
AND CLNT.LANGUAGE = USERENV('LANG')

Columns