View: OKL_TRX_CONTRACTS_V

View Text

SELECT TCNB.ROWID ROW_ID
, TCNB.ID ID
, TCNB.TRX_NUMBER TRX_NUMBER
, TCNB.OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER
, TCNB.RBR_CODE RBR_CODE
, TCNB.RPY_CODE RPY_CODE
, TCNB.RVN_CODE RVN_CODE
, TCNB.TRN_CODE TRN_CODE
, TCNB.KHR_ID_NEW KHR_ID_NEW
, TCNB.PVN_ID PVN_ID
, TCNB.PDT_ID PDT_ID
, TCNB.QTE_ID QTE_ID
, TCNB.AES_ID AES_ID
, TCNB.CODE_COMBINATION_ID CODE_COMBINATION_ID
, TCNB.TAX_DEDUCTIBLE_LOCAL TAX_DEDUCTIBLE_LOCAL
, TCNB.TAX_DEDUCTIBLE_CORPORATE TAX_DEDUCTIBLE_CORPORATE
, TCNB.DATE_ACCRUAL DATE_ACCRUAL
, TCNB.ACCRUAL_STATUS_YN ACCRUAL_STATUS_YN
, TCNB.UPDATE_STATUS_YN UPDATE_STATUS_YN
, TCNB.DATE_TRANSACTION_OCCURRED DATE_TRANSACTION_OCCURRED
, TCNB.TRY_ID TRY_ID
, TCNB.TSU_CODE TSU_CODE
, TCNB.DESCRIPTION DESCRIPTION
, TCNB.AMOUNT AMOUNT
, TCNB.SET_OF_BOOKS_ID SET_OF_BOOKS_ID
, TCNB.CURRENCY_CODE CURRENCY_CODE
, TCNB.CURRENCY_CONVERSION_TYPE CURRENCY_CONVERSION_TYPE
, TCNB.CURRENCY_CONVERSION_RATE CURRENCY_CONVERSION_RATE
, TCNB.CURRENCY_CONVERSION_DATE CURRENCY_CONVERSION_DATE
, TCNB.TCN_TYPE TCN_TYPE
, TCNB.KHR_ID KHR_ID
, TCNB.KHR_ID_OLD KHR_ID_OLD
, TCNB.TMT_EVERGREEN_YN TMT_EVERGREEN_YN
, TCNB.TMT_CLOSE_BALANCES_YN TMT_CLOSE_BALANCES_YN
, TCNB.TMT_ACCOUNTING_ENTRIES_YN TMT_ACCOUNTING_ENTRIES_YN
, TCNB.TMT_CANCEL_INSURANCE_YN TMT_CANCEL_INSURANCE_YN
, TCNB.TMT_ASSET_DISPOSITION_YN TMT_ASSET_DISPOSITION_YN
, TCNB.TMT_AMORTIZATION_YN TMT_AMORTIZATION_YN
, TCNB.TMT_ASSET_RETURN_YN TMT_ASSET_RETURN_YN
, TCNB.TMT_CONTRACT_UPDATED_YN TMT_CONTRACT_UPDATED_YN
, TCNB.TMT_RECYCLE_YN TMT_RECYCLE_YN
, TCNB.TMT_VALIDATED_YN TMT_VALIDATED_YN
, TCNB.TMT_STREAMS_UPDATED_YN TMT_STREAMS_UPDATED_YN
, TCNB.RJN_CODE RJN_CODE
, TCNB.PARTY_REL_ID1_OLD PARTY_REL_ID1_OLD
, TCNB.PARTY_REL_ID2_OLD PARTY_REL_ID2_OLD
, TCNB.PARTY_REL_ID1_NEW PARTY_REL_ID1_NEW
, TCNB.PARTY_REL_ID2_NEW PARTY_REL_ID2_NEW
, TCNB.COMPLETE_TRANSFER_YN COMPLETE_TRANSFER_YN
, TCNB.ACCRUAL_ACTIVITY ACCRUAL_ACTIVITY
, TCNB.TMT_SPLIT_ASSET_YN TMT_SPLIT_ASSET_YN
, TCNB.TMT_GENERIC_FLAG1_YN TMT_GENERIC_FLAG1_YN
, TCNB.TMT_GENERIC_FLAG2_YN TMT_GENERIC_FLAG2_YN
, TCNB.TMT_GENERIC_FLAG3_YN TMT_GENERIC_FLAG3_YN
, TCNB.ATTRIBUTE_CATEGORY ATTRIBUTE_CATEGORY
, TCNB.ATTRIBUTE1 ATTRIBUTE1
, TCNB.ATTRIBUTE2 ATTRIBUTE2
, TCNB.ATTRIBUTE3 ATTRIBUTE3
, TCNB.ATTRIBUTE4 ATTRIBUTE4
, TCNB.ATTRIBUTE5 ATTRIBUTE5
, TCNB.ATTRIBUTE6 ATTRIBUTE6
, TCNB.ATTRIBUTE7 ATTRIBUTE7
, TCNB.ATTRIBUTE8 ATTRIBUTE8
, TCNB.ATTRIBUTE9 ATTRIBUTE9
, TCNB.ATTRIBUTE10 ATTRIBUTE10
, TCNB.ATTRIBUTE11 ATTRIBUTE11
, TCNB.ATTRIBUTE12 ATTRIBUTE12
, TCNB.ATTRIBUTE13 ATTRIBUTE13
, TCNB.ATTRIBUTE14 ATTRIBUTE14
, TCNB.ATTRIBUTE15 ATTRIBUTE15
, TCNB.ORG_ID ORG_ID
, TCNB.REQUEST_ID REQUEST_ID
, TCNB.PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID
, TCNB.PROGRAM_ID PROGRAM_ID
, TCNB.PROGRAM_UPDATE_DATE PROGRAM_UPDATE_DATE
, TCNB.CREATED_BY CREATED_BY
, TCNB.CREATION_DATE CREATION_DATE
, TCNB.LAST_UPDATED_BY LAST_UPDATED_BY
, TCNB.LAST_UPDATE_DATE LAST_UPDATE_DATE
, TCNB.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
FROM OKL_TRX_CONTRACTS TCNB
WHERE NVL(ORG_ID
, NVL(TO_NUMBER(DECODE( SUBSTRB(USERENV('CLIENT_INFO')
, 1
, 1)
, ' '
, NULL
, SUBSTRB(USERENV('CLIENT_INFO')
, 1
, 10)))
, -99)) = NVL(TO_NUMBER(DECODE( SUBSTRB(USERENV('CLIENT_INFO')
, 1
, 1)
, ' '
, NULL
, SUBSTRB(USERENV('CLIENT_INFO')
, 1
, 10)))
, -99)

Columns