[Home] [Help]
| Product: | OKL - Leasing and Finance Management |
|---|---|
| Description: | View for table OKL_CSE_PTY_VISITS_B |
| Implementation/DBA Data: | Not implemented in this database |
SELECT CPEB.ROWID ROW_ID
, CPEB.ID ID
, CPEB.OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER
, CPET.SFWT_FLAG SFWT_FLAG
, CPEB.CAC_ID CAC_ID
, CPEB.QUOTE_AMOUNT QUOTE_AMOUNT
, CPEB.SEQUENCE_NUMBER SEQUENCE_NUMBER
, CPEB.QUOTE_DATE QUOTE_DATE
, CPET.QUOTE_DESCRIPTION QUOTE_DESCRIPTION
, CPEB.VISIT_STATUS VISIT_STATUS
, CPEB.NOTE_SUBMISSION_METHOD NOTE_SUBMISSION_METHOD
, CPEB.ATTRIBUTE_CATEGORY ATTRIBUTE_CATEGORY
, CPEB.ATTRIBUTE1 ATTRIBUTE1
, CPEB.ATTRIBUTE2 ATTRIBUTE2
, CPEB.ATTRIBUTE3 ATTRIBUTE3
, CPEB.ATTRIBUTE4 ATTRIBUTE4
, CPEB.ATTRIBUTE5 ATTRIBUTE5
, CPEB.ATTRIBUTE6 ATTRIBUTE6
, CPEB.ATTRIBUTE7 ATTRIBUTE7
, CPEB.ATTRIBUTE8 ATTRIBUTE8
, CPEB.ATTRIBUTE9 ATTRIBUTE9
, CPEB.ATTRIBUTE10 ATTRIBUTE10
, CPEB.ATTRIBUTE11 ATTRIBUTE11
, CPEB.ATTRIBUTE12 ATTRIBUTE12
, CPEB.ATTRIBUTE13 ATTRIBUTE13
, CPEB.ATTRIBUTE14 ATTRIBUTE14
, CPEB.ATTRIBUTE15 ATTRIBUTE15
, CPEB.SNM_CODE SNM_CODE
, CPEB.VST_CODE VST_CODE
, CPEB.VST_ID VST_ID
, CPEB.ORG_ID ORG_ID
, CPEB.REQUEST_ID REQUEST_ID
, CPEB.PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID
, CPEB.PROGRAM_ID PROGRAM_ID
, CPEB.PROGRAM_UPDATE_DATE PROGRAM_UPDATE_DATE
, CPEB.CREATED_BY CREATED_BY
, CPEB.CREATION_DATE CREATION_DATE
, CPEB.LAST_UPDATED_BY LAST_UPDATED_BY
, CPEB.LAST_UPDATE_DATE LAST_UPDATE_DATE
, CPEB.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
FROM ZOKL_CSE_PTY_VISITS_B CPEB
, ZOKL_CSE_PTY_VISITS_TL CPET
WHERE CPEB.ID = CPET.ID
AND CPET.LANGUAGE = USERENV('LANG')