View: OKL_TRNS_ACC_DSTRS_UV

Product:	OKL - Lease and Finance Management
Description:
Implementation/DBA Data:	APPS.OKL_TRNS_ACC_DSTRS_UV

View Text

SELECT TABB.ROWID ROW_ID
, TABB.ID ID
, TABB.OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER
, TABB.TEMPLATE_ID TEMPLATE_ID
, TABB.CR_DR_FLAG
, TABB.AE_LINE_TYPE
, TABB.ORG_ID ORG_ID
, TABB.SET_OF_BOOKS_ID SET_OF_BOOKS_ID
, TABB.CODE_COMBINATION_ID CODE_COMBINATION_ID
, TABB.CURRENCY_CODE CURRENCY_CODE
, TABB.CURRENCY_CONVERSION_TYPE CURRENCY_CONVERSION_TYPE
, TABB.SOURCE_ID SOURCE_ID
, TABB.SOURCE_TABLE SOURCE_TABLE
, TABB.AMOUNT AMOUNT
, TABB.ACCOUNTED_AMOUNT ACCOUNTED_AMOUNT
, TABB.GL_DATE GL_DATE
, TABB.PERCENTAGE PERCENTAGE
, TABB.COMMENTS COMMENTS
, TABB.POST_REQUEST_ID POST_REQUEST_ID
, TABB.CURRENCY_CONVERSION_DATE CURRENCY_CONVERSION_DATE
, TABB.CURRENCY_CONVERSION_RATE CURRENCY_CONVERSION_RATE
, TABB.ATTRIBUTE_CATEGORY ATTRIBUTE_CATEGORY
, TABB.ATTRIBUTE1 ATTRIBUTE1
, TABB.ATTRIBUTE2 ATTRIBUTE2
, TABB.ATTRIBUTE3 ATTRIBUTE3
, TABB.ATTRIBUTE4 ATTRIBUTE4
, TABB.ATTRIBUTE5 ATTRIBUTE5
, TABB.ATTRIBUTE6 ATTRIBUTE6
, TABB.ATTRIBUTE7 ATTRIBUTE7
, TABB.ATTRIBUTE8 ATTRIBUTE8
, TABB.ATTRIBUTE9 ATTRIBUTE9
, TABB.ATTRIBUTE10 ATTRIBUTE10
, TABB.ATTRIBUTE11 ATTRIBUTE11
, TABB.ATTRIBUTE12 ATTRIBUTE12
, TABB.ATTRIBUTE13 ATTRIBUTE13
, TABB.ATTRIBUTE14 ATTRIBUTE14
, TABB.ATTRIBUTE15 ATTRIBUTE15
, TABB.REQUEST_ID REQUEST_ID
, TABB.PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID
, TABB.PROGRAM_ID PROGRAM_ID
, TABB.PROGRAM_UPDATE_DATE PROGRAM_UPDATE_DATE
, TABB.CREATED_BY CREATED_BY
, TABB.CREATION_DATE CREATION_DATE
, TABB.LAST_UPDATED_BY LAST_UPDATED_BY
, TABB.LAST_UPDATE_DATE LAST_UPDATE_DATE
, TABB.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, GCCK.CONCATENATED_SEGMENTS
, OKL_ACCOUNTING_UTIL.GET_CONCATE_DESC(GCCK.CHART_OF_ACCOUNTS_ID
, GCCK.CONCATENATED_SEGMENTS)
FROM OKL_TRNS_ACC_DSTRS TABB
, GL_CODE_COMBINATIONS_KFV GCCK
WHERE TABB.CODE_COMBINATION_ID = GCCK.CODE_COMBINATION_ID

Columns