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.

[Home] [Help]

View: ZOKL_BANKRUPTCIES_V

Product:	OKL - Leasing and Finance Management
Description:	View for table OKL_BANKRUPTCIES_B
Implementation/DBA Data:	Not implemented in this database

View Text

SELECT BANB.ROWID ROW_ID
, BANB.ID ID
, BANB.OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER
, BANT.SFWT_FLAG SFWT_FLAG
, BANB.BRS_CODE BRS_CODE
, BANB.CAC_ID CAC_ID
, BANB.PTY_ID PTY_ID
, BANB.SEQUENCE_NUMBER SEQUENCE_NUMBER
, BANT.BANKRUPTCY_FILED_NAME BANKRUPTCY_FILED_NAME
, BANB.BANKRUPTCY_CASE_NUMBER BANKRUPTCY_CASE_NUMBER
, BANB.CEASE_COLLECTION_ACTIVITY_YN CEASE_COLLECTION_ACTIVITY_YN
, BANT.BANKRUPTCY_CATEGORY BANKRUPTCY_CATEGORY
, BANT.BANKRUPTCY_FILE_CITY BANKRUPTCY_FILE_CITY
, BANB.BANKRUPTCY_FILE_DATE BANKRUPTCY_FILE_DATE
, BANB.COURT_ORDER_DATE COURT_ORDER_DATE
, BANB.TRUSTEE_CONTACT_ID TRUSTEE_CONTACT_ID
, BANB.DEBTOR_CONTACT_ID DEBTOR_CONTACT_ID
, BANT.BANKRUPTCY_COMMENTS BANKRUPTCY_COMMENTS
, BANB.PROOF_OF_CLAIM_BAR_DATE PROOF_OF_CLAIM_BAR_DATE
, BANB.IMMEDIATE_REPURCHASE_YN IMMEDIATE_REPURCHASE_YN
, BANB.CHANGE_FUTURE_INVOICE_DTLS_YN CHANGE_FUTURE_INVOICE_DTLS_YN
, BANB.NOTICE_OF_ASSIGNMENT_TAKEN_YN NOTICE_OF_ASSIGNMENT_TAKEN_YN
, BANT.BANKRUPTCY_STATE BANKRUPTCY_STATE
, BANB.BANKRUPTCY_STATUS BANKRUPTCY_STATUS
, BANB.TURN_OFF_INVOICING_YN TURN_OFF_INVOICING_YN
, BANB.ATTRIBUTE_CATEGORY ATTRIBUTE_CATEGORY
, BANB.ATTRIBUTE1 ATTRIBUTE1
, BANB.ATTRIBUTE2 ATTRIBUTE2
, BANB.ATTRIBUTE3 ATTRIBUTE3
, BANB.ATTRIBUTE4 ATTRIBUTE4
, BANB.ATTRIBUTE5 ATTRIBUTE5
, BANB.ATTRIBUTE6 ATTRIBUTE6
, BANB.ATTRIBUTE7 ATTRIBUTE7
, BANB.ATTRIBUTE8 ATTRIBUTE8
, BANB.ATTRIBUTE9 ATTRIBUTE9
, BANB.ATTRIBUTE10 ATTRIBUTE10
, BANB.ATTRIBUTE11 ATTRIBUTE11
, BANB.ATTRIBUTE12 ATTRIBUTE12
, BANB.ATTRIBUTE13 ATTRIBUTE13
, BANB.ATTRIBUTE14 ATTRIBUTE14
, BANB.ATTRIBUTE15 ATTRIBUTE15
, BANB.ORG_ID ORG_ID
, BANB.REQUEST_ID REQUEST_ID
, BANB.PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID
, BANB.PROGRAM_ID PROGRAM_ID
, BANB.PROGRAM_UPDATE_DATE PROGRAM_UPDATE_DATE
, BANB.CREATED_BY CREATED_BY
, BANB.CREATION_DATE CREATION_DATE
, BANB.LAST_UPDATED_BY LAST_UPDATED_BY
, BANB.LAST_UPDATE_DATE LAST_UPDATE_DATE
, BANB.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
FROM ZOKL_BANKRUPTCIES_B BANB
, ZOKL_BANKRUPTCIES_TL BANT
WHERE BANB.ID = BANT.ID
AND BANT.LANGUAGE = USERENV('LANG')

Columns

Name
ROW_ID
ID
OBJECT_VERSION_NUMBER
SFWT_FLAG
BRS_CODE
CAC_ID
PTY_ID
SEQUENCE_NUMBER
BANKRUPTCY_FILED_NAME
BANKRUPTCY_CASE_NUMBER
CEASE_COLLECTION_ACTIVITY_YN
BANKRUPTCY_CATEGORY
BANKRUPTCY_FILE_CITY
BANKRUPTCY_FILE_DATE
COURT_ORDER_DATE
TRUSTEE_CONTACT_ID
DEBTOR_CONTACT_ID
BANKRUPTCY_COMMENTS
PROOF_OF_CLAIM_BAR_DATE
IMMEDIATE_REPURCHASE_YN
CHANGE_FUTURE_INVOICE_DTLS_YN
NOTICE_OF_ASSIGNMENT_TAKEN_YN
BANKRUPTCY_STATE
BANKRUPTCY_STATUS
TURN_OFF_INVOICING_YN
ATTRIBUTE_CATEGORY
ATTRIBUTE1
ATTRIBUTE2
ATTRIBUTE3
ATTRIBUTE4
ATTRIBUTE5
ATTRIBUTE6
ATTRIBUTE7
ATTRIBUTE8
ATTRIBUTE9
ATTRIBUTE10
ATTRIBUTE11
ATTRIBUTE12
ATTRIBUTE13
ATTRIBUTE14
ATTRIBUTE15
ORG_ID
REQUEST_ID
PROGRAM_APPLICATION_ID
PROGRAM_ID
PROGRAM_UPDATE_DATE
CREATED_BY
CREATION_DATE
LAST_UPDATED_BY
LAST_UPDATE_DATE
LAST_UPDATE_LOGIN