FND Design Data [Home] [Help]

View: OKL_COST_ADJUSTMENTS_V

Product: OKL - Lease and Finance Management
Description: View for OKL_COST_ADJUSTMENTS_B and OKL_COST_ADJUSTMENTS_TL
Implementation/DBA Data: ViewAPPS.OKL_COST_ADJUSTMENTS_V
View Text

SELECT CDJ.ROWID ROW_ID
, CDJ.ID ID
, CDJ.OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER
, CDJ.ATTRIBUTE_CATEGORY ATTRIBUTE_CATEGORY
, CDJ.ATTRIBUTE1 ATTRIBUTE1
, CDJ.ATTRIBUTE2 ATTRIBUTE2
, CDJ.ATTRIBUTE3 ATTRIBUTE3
, CDJ.ATTRIBUTE4 ATTRIBUTE4
, CDJ.ATTRIBUTE5 ATTRIBUTE5
, CDJ.ATTRIBUTE6 ATTRIBUTE6
, CDJ.ATTRIBUTE7 ATTRIBUTE7
, CDJ.ATTRIBUTE8 ATTRIBUTE8
, CDJ.ATTRIBUTE9 ATTRIBUTE9
, CDJ.ATTRIBUTE10 ATTRIBUTE10
, CDJ.ATTRIBUTE11 ATTRIBUTE11
, CDJ.ATTRIBUTE12 ATTRIBUTE12
, CDJ.ATTRIBUTE13 ATTRIBUTE13
, CDJ.ATTRIBUTE14 ATTRIBUTE14
, CDJ.ATTRIBUTE15 ATTRIBUTE15
, CDJ.CREATED_BY CREATED_BY
, CDJ.CREATION_DATE CREATION_DATE
, CDJ.LAST_UPDATED_BY LAST_UPDATED_BY
, CDJ.LAST_UPDATE_DATE LAST_UPDATE_DATE
, CDJ.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, CDJ.PARENT_OBJECT_CODE PARENT_OBJECT_CODE
, CDJ.PARENT_OBJECT_ID PARENT_OBJECT_ID
, CDJ.ADJUSTMENT_SOURCE_TYPE ADJUSTMENT_SOURCE_TYPE
, CDJ.ADJUSTMENT_SOURCE_ID ADJUSTMENT_SOURCE_ID
, CDJ.BASIS BASIS
, CDJ.VALUE VALUE
, CDJ.PROCESSING_TYPE PROCESSING_TYPE
, CDJ.SUPPLIER_ID SUPPLIER_ID
, CDJ.DEFAULT_SUBSIDY_AMOUNT DEFAULT_SUBSIDY_AMOUNT
, CDJ.PERCENT_BASIS_VALUE PERCENT_BASIS_VALUE
, CDJ.STREAM_TYPE_ID STREAM_TYPE_ID
, CDJT.SHORT_DESCRIPTION SHORT_DESCRIPTION
, CDJT.DESCRIPTION DESCRIPTION
, CDJT.COMMENTS COMMENTS
FROM OKL_COST_ADJUSTMENTS_B CDJ
, OKL_COST_ADJUSTMENTS_TL CDJT
WHERE CDJ.ID = CDJT.ID
AND CDJT.LANGUAGE = USERENV('LANG')

Columns

Name
ROW_ID
ID
OBJECT_VERSION_NUMBER
ATTRIBUTE_CATEGORY
ATTRIBUTE1
ATTRIBUTE2
ATTRIBUTE3
ATTRIBUTE4
ATTRIBUTE5
ATTRIBUTE6
ATTRIBUTE7
ATTRIBUTE8
ATTRIBUTE9
ATTRIBUTE10
ATTRIBUTE11
ATTRIBUTE12
ATTRIBUTE13
ATTRIBUTE14
ATTRIBUTE15
CREATED_BY
CREATION_DATE
LAST_UPDATED_BY
LAST_UPDATE_DATE
LAST_UPDATE_LOGIN
PARENT_OBJECT_CODE
PARENT_OBJECT_ID
ADJUSTMENT_SOURCE_TYPE
ADJUSTMENT_SOURCE_ID
BASIS
VALUE
PROCESSING_TYPE
SUPPLIER_ID
DEFAULT_SUBSIDY_AMOUNT
PERCENT_BASIS_VALUE
STREAM_TYPE_ID
SHORT_DESCRIPTION
DESCRIPTION
COMMENTS