VIEW: APPS.OKL_AM_TRMNT_TRANSACTIONS_UV

Source

View Text - Preformatted

SELECT K.ID ID, K.CONTRACT_NUMBER CONTRACT_NUMBER, K.START_DATE CONTRACT_START_DATE, K.END_DATE CONTRACT_END_DATE, K.DESCRIPTION CONTRACT_DESCRIPTION, K.STS_CODE STS_CODE, S.MEANING CONTRACT_STATUS, T.ID TRANSACTION_ID, T.CREATION_DATE TRANSACTION_DATE, T.TMT_RECYCLE_YN TRANSACTION_RECYCLE_YN, T.TCN_TYPE TCN_TYPE, T.TMT_STATUS_CODE TSU_CODE, F1.MEANING TRANSACTION_STATUS, T.TRN_CODE TRN_CODE, F2.MEANING TERMINATION_REASON, T.TMT_EVERGREEN_YN TMT_EVERGREEN_YN, T.TMT_CLOSE_BALANCES_YN TMT_CLOSE_BALANCES_YN, T.TMT_ACCOUNTING_ENTRIES_YN TMT_ACCOUNTING_ENTRIES_YN, T.TMT_CANCEL_INSURANCE_YN TMT_CANCEL_INSURANCE_YN, T.TMT_ASSET_DISPOSITION_YN TMT_ASSET_DISPOSITION_YN, T.TMT_AMORTIZATION_YN TMT_AMORTIZATION_YN, T.TMT_ASSET_RETURN_YN TMT_ASSET_RETURN_YN, T.TMT_CONTRACT_UPDATED_YN TMT_CONTRACT_UPDATED_YN, T.TMT_RECYCLE_YN TMT_RECYCLE_YN, T.TMT_VALIDATED_YN TMT_VALIDATED_YN, T.TMT_STREAMS_UPDATED_YN TMT_STREAMS_UPDATED_YN, T.TMT_SPLIT_ASSET_YN TMT_SPLIT_ASSET_YN, T.TMT_GENERIC_FLAG1_YN TMT_GENERIC_FLAG1_YN, T.TMT_GENERIC_FLAG2_YN TMT_GENERIC_FLAG2_YN, T.TMT_GENERIC_FLAG3_YN TMT_GENERIC_FLAG3_YN, T.CREATION_DATE CREATION_DATE, T.DESCRIPTION DESCRIPTION, F3.MEANING TCN_MEANING, T.CURRENCY_CODE CURRENCY_CODE, K.AUTHORING_ORG_ID ORG_ID FROM OKL_K_HEADERS_FULL_V K,OKL_TRX_CONTRACTS T,FND_LOOKUPS F1,FND_LOOKUPS F2,OKC_STATUSES_V S,FND_LOOKUPS F3 WHERE K.ID = T.KHR_ID AND T.TCN_TYPE IN ( 'TMT', 'ALT','EVG') AND K.STS_CODE = S.CODE AND T.TMT_STATUS_CODE = F1.LOOKUP_CODE AND F1.LOOKUP_TYPE = 'OKL_TRANSACTION_STATUS' AND T.TRN_CODE = F2.LOOKUP_CODE AND F2.LOOKUP_TYPE = 'OKC_TERMINATION_REASON' AND T.TCN_TYPE = F3.LOOKUP_CODE AND F3.LOOKUP_TYPE = 'OKL_TCN_TYPE'

View Text - HTML Formatted

SELECT K.ID ID
, K.CONTRACT_NUMBER CONTRACT_NUMBER
, K.START_DATE CONTRACT_START_DATE
, K.END_DATE CONTRACT_END_DATE
, K.DESCRIPTION CONTRACT_DESCRIPTION
, K.STS_CODE STS_CODE
, S.MEANING CONTRACT_STATUS
, T.ID TRANSACTION_ID
, T.CREATION_DATE TRANSACTION_DATE
, T.TMT_RECYCLE_YN TRANSACTION_RECYCLE_YN
, T.TCN_TYPE TCN_TYPE
, T.TMT_STATUS_CODE TSU_CODE
, F1.MEANING TRANSACTION_STATUS
, T.TRN_CODE TRN_CODE
, F2.MEANING TERMINATION_REASON
, T.TMT_EVERGREEN_YN TMT_EVERGREEN_YN
, T.TMT_CLOSE_BALANCES_YN TMT_CLOSE_BALANCES_YN
, T.TMT_ACCOUNTING_ENTRIES_YN TMT_ACCOUNTING_ENTRIES_YN
, T.TMT_CANCEL_INSURANCE_YN TMT_CANCEL_INSURANCE_YN
, T.TMT_ASSET_DISPOSITION_YN TMT_ASSET_DISPOSITION_YN
, T.TMT_AMORTIZATION_YN TMT_AMORTIZATION_YN
, T.TMT_ASSET_RETURN_YN TMT_ASSET_RETURN_YN
, T.TMT_CONTRACT_UPDATED_YN TMT_CONTRACT_UPDATED_YN
, T.TMT_RECYCLE_YN TMT_RECYCLE_YN
, T.TMT_VALIDATED_YN TMT_VALIDATED_YN
, T.TMT_STREAMS_UPDATED_YN TMT_STREAMS_UPDATED_YN
, T.TMT_SPLIT_ASSET_YN TMT_SPLIT_ASSET_YN
, T.TMT_GENERIC_FLAG1_YN TMT_GENERIC_FLAG1_YN
, T.TMT_GENERIC_FLAG2_YN TMT_GENERIC_FLAG2_YN
, T.TMT_GENERIC_FLAG3_YN TMT_GENERIC_FLAG3_YN
, T.CREATION_DATE CREATION_DATE
, T.DESCRIPTION DESCRIPTION
, F3.MEANING TCN_MEANING
, T.CURRENCY_CODE CURRENCY_CODE
, K.AUTHORING_ORG_ID ORG_ID
FROM OKL_K_HEADERS_FULL_V K
, OKL_TRX_CONTRACTS T
, FND_LOOKUPS F1
, FND_LOOKUPS F2
, OKC_STATUSES_V S
, FND_LOOKUPS F3
WHERE K.ID = T.KHR_ID
AND T.TCN_TYPE IN ( 'TMT'
, 'ALT'
, 'EVG')
AND K.STS_CODE = S.CODE
AND T.TMT_STATUS_CODE = F1.LOOKUP_CODE
AND F1.LOOKUP_TYPE = 'OKL_TRANSACTION_STATUS'
AND T.TRN_CODE = F2.LOOKUP_CODE
AND F2.LOOKUP_TYPE = 'OKC_TERMINATION_REASON'
AND T.TCN_TYPE = F3.LOOKUP_CODE
AND F3.LOOKUP_TYPE = 'OKL_TCN_TYPE'