Product: | OKL - Lease and Finance Management |
---|---|
Description: | View for OKL_COST_ADJUSTMENTS_B and OKL_COST_ADJUSTMENTS_TL |
Implementation/DBA Data: | APPS.OKL_COST_ADJUSTMENTS_V |
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')