FND Design Data [Home] [Help]

View: OKL_VP_CHANGE_REQUESTS_V

Product: OKL - Leasing and Finance Management
Description: Entity View for table OKL_VP_CHANGE_REQUESTS
Implementation/DBA Data: ViewAPPS.OKL_VP_CHANGE_REQUESTS_V
View Text

SELECT VCR.ROWID ROW_ID
, VCR.ID ID
, VCR.OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER
, VCR.CHANGE_REQUEST_NUMBER CHANGE_REQUEST_NUMBER
, VCR.CHR_ID CHR_ID
, VCR.CHANGE_TYPE_CODE CHANGE_TYPE_CODE
, VCR.STATUS_CODE STATUS_CODE
, VCR.REQUEST_DATE REQUEST_DATE
, VCR.EFFECTIVE_DATE EFFECTIVE_DATE
, VCR.APPROVED_DATE APPROVED_DATE
, VCR.REJECTED_DATE REJECTED_DATE
, VCR.INEFFECTIVE_DATE INEFFECTIVE_DATE
, VCR.APPLIED_DATE APPLIED_DATE
, VCR.ATTRIBUTE_CATEGORY ATTRIBUTE_CATEGORY
, VCR.ATTRIBUTE1 ATTRIBUTE1
, VCR.ATTRIBUTE2 ATTRIBUTE2
, VCR.ATTRIBUTE3 ATTRIBUTE3
, VCR.ATTRIBUTE4 ATTRIBUTE4
, VCR.ATTRIBUTE5 ATTRIBUTE5
, VCR.ATTRIBUTE6 ATTRIBUTE5
, VCR.ATTRIBUTE7 ATTRIBUTE7
, VCR.ATTRIBUTE8 ATTRIBUTE8
, VCR.ATTRIBUTE9 ATTRIBUTE9
, VCR.ATTRIBUTE10 ATTRIBUTE10
, VCR.ATTRIBUTE11 ATTRIBUTE11
, VCR.ATTRIBUTE12 ATTRIBUTE12
, VCR.ATTRIBUTE13 ATTRIBUTE13
, VCR.ATTRIBUTE14 ATTRIBUTE14
, VCR.ATTRIBUTE15 ATTRIBUTE15
, VCR.REQUEST_ID REQUEST_ID
, VCR.PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID
, VCR.PROGRAM_ID PROGRAM_ID
, VCR.PROGRAM_UPDATE_DATE PROGRAM_UPDATE_DATE
, VCR.CREATED_BY CREATED_BY
, VCR.CREATION_DATE CREATION_DATE
, VCR.LAST_UPDATED_BY LAST_UPDATED_BY
, VCR.LAST_UPDATE_DATE LAST_UPDATE_DATE
, VCR.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
FROM OKL_VP_CHANGE_REQUESTS VCR

Columns

Name
ROW_ID
ID
OBJECT_VERSION_NUMBER
CHANGE_REQUEST_NUMBER
CHR_ID
CHANGE_TYPE_CODE
STATUS_CODE
REQUEST_DATE
EFFECTIVE_DATE
APPROVED_DATE
REJECTED_DATE
INEFFECTIVE_DATE
APPLIED_DATE
ATTRIBUTE_CATEGORY
ATTRIBUTE1
ATTRIBUTE2
ATTRIBUTE3
ATTRIBUTE4
ATTRIBUTE5
ATTRIBUTE6
ATTRIBUTE7
ATTRIBUTE8
ATTRIBUTE9
ATTRIBUTE10
ATTRIBUTE11
ATTRIBUTE12
ATTRIBUTE13
ATTRIBUTE14
ATTRIBUTE15
REQUEST_ID
PROGRAM_APPLICATION_ID
PROGRAM_ID
PROGRAM_UPDATE_DATE
CREATED_BY
CREATION_DATE
LAST_UPDATED_BY
LAST_UPDATE_DATE
LAST_UPDATE_LOGIN