View: OKL_TRX_CONTRACTS_UV

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

View Text

SELECT OTC.ID ID
, OTC.TRX_NUMBER TRANSACTION_NUMBER
, OTC.KHR_ID_NEW KHR_ID_NEW
, OTC.KHR_ID_OLD KHR_ID_OLD
, OTC.KHR_ID KHR_ID
, OTC.PVN_ID PVN_ID
, OTC.PDT_ID PDT_ID
, OTC.RBR_CODE RBR_CODE
, OTC.RPY_CODE RPY_CODE
, OTC.RVN_CODE RVN_CODE
, OTC.TRN_CODE TRN_CODE
, OTC.QTE_ID QTE_ID
, OTC.AES_ID AES_ID
, OTC.CODE_COMBINATION_ID CODE_COMBINATION_ID
, OTC.TCN_TYPE TCN_TYPE
, OTC.OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER
, OTC.DATE_ACCRUAL DATE_ACCRUAL
, OTC.ACCRUAL_STATUS_YN ACCRUAL_STATUS_YN
, OTC.UPDATE_STATUS_YN UPDATE_STATUS_YN
, OTC.TAX_DEDUCTIBLE_LOCAL TAX_DEDUCTIBLE_LOCAL
, OTC.TAX_DEDUCTIBLE_CORPORATE TAX_DEDUCTIBLE_CORPORATE
, OTC.AMOUNT AMOUNT
, OTC.TMT_SPLIT_ASSET_YN TMT_SPLIT_ASSET_YN
, OTC.TMT_GENERIC_FLAG1_YN TMT_GENERIC_FLAG1_YN
, OTC.TMT_GENERIC_FLAG2_YN TMT_GENERIC_FLAG2_YN
, OTC.TMT_GENERIC_FLAG3_YN TMT_GENERIC_FLAG3_YN
, OTC.ATTRIBUTE_CATEGORY ATTRIBUTE_CATEGORY
, OTC.ATTRIBUTE1 ATTRIBUTE1
, OTC.ATTRIBUTE2 ATTRIBUTE2
, OTC.ATTRIBUTE3 ATTRIBUTE3
, OTC.ATTRIBUTE4 ATTRIBUTE4
, OTC.ATTRIBUTE5 ATTRIBUTE5
, OTC.ATTRIBUTE6 ATTRIBUTE6
, OTC.ATTRIBUTE7 ATTRIBUTE7
, OTC.ATTRIBUTE8 ATTRIBUTE8
, OTC.ATTRIBUTE9 ATTRIBUTE9
, OTC.ATTRIBUTE10 ATTRIBUTE10
, OTC.ATTRIBUTE11 ATTRIBUTE11
, OTC.ATTRIBUTE12 ATTRIBUTE12
, OTC.ATTRIBUTE13 ATTRIBUTE13
, OTC.ATTRIBUTE14 ATTRIBUTE14
, OTC.ATTRIBUTE15 ATTRIBUTE15
, OTC.ORG_ID ORG_ID
, OTC.REQUEST_ID REQUEST_ID
, OTC.PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID
, OTC.PROGRAM_ID PROGRAM_ID
, OTC.PROGRAM_UPDATE_DATE PROGRAM_UPDATE_DATE
, OTC.CREATED_BY CREATED_BY
, OTC.CREATION_DATE CREATION_DATE
, OTC.LAST_UPDATED_BY LAST_UPDATED_BY
, OTC.LAST_UPDATE_DATE LAST_UPDATE_DATE
, OTC.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, OTC.TRY_ID TRY_ID
, OTC.TSU_CODE TSU_CODE
, OTC.SET_OF_BOOKS_ID SET_OF_BOOKS_ID
, OTC.DESCRIPTION DESCRIPTION
, OTC.DATE_TRANSACTION_OCCURRED DATE_TRANSACTION_OCCURRED
, OTC.CURRENCY_CODE CURRENCY_CODE
, OTC.CURRENCY_CONVERSION_TYPE CURRENCY_CONVERSION_TYPE
, OTC.CURRENCY_CONVERSION_RATE CURRENCY_CONVERSION_RATE
, OTC.CURRENCY_CONVERSION_DATE CURRENCY_CONVERSION_DATE
, OKHB.CONTRACT_NUMBER CONTRACT_NUMBER
, OP.NAME PRODUCT_NAME
, OTQB.QUOTE_NUMBER QUOTE_NUMBER
, OPR.NAME PROVISION_NAME
, OATS.NAME ACC_TEMPLATE_SET
, OKL_ACCOUNTING_UTIL.GET_LOOKUP_MEANING('OKL_REBOOK_REASON'
, OTC.RBR_CODE) REBOOK_REASON
, OKL_ACCOUNTING_UTIL.GET_LOOKUP_MEANING('OKL_REBOOK_PROCESS_TYPE'
, OTC.RPY_CODE) REBOOK_PROCESS_TYPE
, OKL_ACCOUNTING_UTIL.GET_LOOKUP_MEANING('OKL_REVERSE_REASON'
, OTC.RVN_CODE) REVERSE_REASON
, OKL_ACCOUNTING_UTIL.GET_LOOKUP_MEANING('OKL_TERMINATION_REASON'
, OTC.TRN_CODE) TERMINATION_REASON
, OKL_ACCOUNTING_UTIL.GET_LOOKUP_MEANING('OKL_TCN_TYPE'
, OTC.TCN_TYPE) TRANSACTION_CONTRACT
, OKL_ACCOUNTING_UTIL.GET_LOOKUP_MEANING('YES_NO'
, OTC.ACCRUAL_STATUS_YN
, 0
, 0) ACCRUAL_STATUS
, OKL_ACCOUNTING_UTIL.GET_LOOKUP_MEANING('YES_NO'
, OTC.UPDATE_STATUS_YN
, 0
, 0) UPDATE_STATUS
, OKL_ACCOUNTING_UTIL.GET_LOOKUP_MEANING('OKL_TRANSACTION_STATUS'
, OTC.TSU_CODE) TRANSACTION_STATUS
, HP.PARTY_NAME CUSTOMER_NAME
, OTC.CHR_ID CHR_ID
FROM FND_CURRENCIES_TL FCT
, OKL_TRX_CONTRACTS_ALL OTC
, OKC_K_HEADERS_B OKHB
, OKL_PRODUCTS OP
, OKL_TRX_QUOTES_ALL_B OTQB
, OKL_PROVISIONS OPR
, OKL_AE_TMPT_SETS_ALL OATS
, OKL_TRX_TYPES_TL TRYT
, HZ_CUST_ACCOUNTS HCA
, HZ_PARTIES HP
WHERE OTC.KHR_ID = OKHB.ID(+)
AND OTC.PDT_ID = OP.ID(+)
AND OTC.QTE_ID = OTQB.ID(+)
AND OTC.PVN_ID = OPR.ID(+)
AND OTC.AES_ID = OATS.ID(+)
AND OTC.CURRENCY_CODE = FCT.CURRENCY_CODE(+)
AND NVL(FCT.LANGUAGE
, USERENV('LANG')) = USERENV('LANG')
AND OTC.TRY_ID = TRYT.ID(+)
AND NVL(TRYT.LANGUAGE
, USERENV('LANG')) = USERENV('LANG')
AND HCA.PARTY_ID = HP.PARTY_ID
AND OKHB.CUST_ACCT_ID = HCA.CUST_ACCOUNT_ID (+)
AND OTC.TCN_TYPE = 'MAE'

Columns