View: OKL_TXL_CNTRCT_LNS_UV

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

View Text

SELECT OTCL.ID ID
, OTCL.LINE_NUMBER LINE_NUMBER
, OTCL.OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER
, OTCL.KHR_ID KHR_ID
, OTCL.BKT_ID BKT_ID
, OTCL.TCN_ID TCN_ID
, OTCL.RCT_ID RCT_ID
, OTCL.BTC_ID BTC_ID
, OTCL.STY_ID STY_ID
, OTCL.TCL_TYPE TCL_TYPE
, OTCL.DESCRIPTION DESCRIPTION
, OTCL.GL_REVERSAL_YN GL_REVERSAL_YN
, OTCL.KLE_ID_NEW KLE_ID_NEW
, OTCL.PERCENTAGE PERCENTAGE
, OTCL.AMOUNT AMOUNT
, OTCL.ATTRIBUTE_CATEGORY ATTRIBUTE_CATEGORY
, OTCL.ATTRIBUTE1 ATTRIBUTE1
, OTCL.ATTRIBUTE2 ATTRIBUTE2
, OTCL.ATTRIBUTE3 ATTRIBUTE3
, OTCL.ATTRIBUTE4 ATTRIBUTE4
, OTCL.ATTRIBUTE5 ATTRIBUTE5
, OTCL.ATTRIBUTE6 ATTRIBUTE6
, OTCL.ATTRIBUTE7 ATTRIBUTE7
, OTCL.ATTRIBUTE8 ATTRIBUTE8
, OTCL.ATTRIBUTE9 ATTRIBUTE9
, OTCL.ATTRIBUTE10 ATTRIBUTE10
, OTCL.ATTRIBUTE11 ATTRIBUTE11
, OTCL.ATTRIBUTE12 ATTRIBUTE12
, OTCL.ATTRIBUTE13 ATTRIBUTE13
, OTCL.ATTRIBUTE14 ATTRIBUTE14
, OTCL.ATTRIBUTE15 ATTRIBUTE15
, OTCL.ORG_ID ORG_ID
, OTCL.PROGRAM_ID PROGRAM_ID
, OTCL.PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID
, OTCL.REQUEST_ID REQUEST_ID
, OTCL.PROGRAM_UPDATE_DATE PROGRAM_UPDATE_DATE
, OTCL.CREATED_BY CREATED_BY
, OTCL.CREATION_DATE CREATION_DATE
, OTCL.LAST_UPDATED_BY LAST_UPDATED_BY
, OTCL.LAST_UPDATE_DATE LAST_UPDATE_DATE
, OTCL.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, OTCL.AVL_ID AVL_ID
, OTCL.CURRENCY_CODE CURRENCY_CODE
, OKHB.CONTRACT_NUMBER CONTRACT_NUMBER
, OTCR.CHECK_NUMBER CHECK_NUMBER
, OST.NAME STREAM_TYPE
, OKL_ACCOUNTING_UTIL.GET_LOOKUP_MEANING('OKL_STREAM_TYPE_PURPOSE'
, OST.STREAM_TYPE_PURPOSE) STREAM_TYPE_PURPOSE
, OTCB.BATCH_TOTAL BATCH_TOTAL
, OAT.NAME ACCOUNTING_TEMPLATE_NAME
, OAT.START_DATE TEMPLATE_START_DATE
, OAT.END_DATE TEMPLATE_END_DATE
, FCT.NAME CURRENCY
, OKL_ACCOUNTING_UTIL.GET_LOOKUP_MEANING('OKL_TCL_TYPE'
, OTCL.TCL_TYPE) TRANSACTION_CONTRACT_LINE
, OKL_ACCOUNTING_UTIL.GET_LOOKUP_MEANING('YES_NO'
, OTCL.GL_REVERSAL_YN
, 0
, 0) GL_REVERSAL_STATUS
, OTCL.ACCRUAL_RULE_YN ACCRUAL_RULE_YN
FROM FND_CURRENCIES_TL FCT
, OKL_TXL_CNTRCT_LNS OTCL
, OKC_K_HEADERS_ALL_B OKHB
, OKL_TRX_CSH_RCPT_ALL_B OTCR
, OKL_STRM_TYPE_V OST
, OKL_TRX_CSH_BATCH_ALL_B OTCB
, OKL_AE_TEMPLATES_ALL OAT
WHERE OTCL.KHR_ID = OKHB.ID(+)
AND OTCL.RCT_ID = OTCR.ID(+)
AND OTCL.STY_ID = OST.ID(+)
AND OTCL.BTC_ID = OTCB.ID(+)
AND OTCL.AVL_ID = OAT.ID(+)
AND OTCL.CURRENCY_CODE = FCT.CURRENCY_CODE(+)
AND NVL(FCT.LANGUAGE
, USERENV('LANG')) = USERENV('LANG')

Columns