VIEW: APPS.OKL_TRNS_ACC_DSTRS_UV

Source

View Text - Preformatted

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

View Text - HTML Formatted

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