[Home] [Help]
View: OKL_STM_TRANSACTIONS_UV
View Text
SELECT DISTINCT STMB.TRANSACTION_NUMBER TRANSACTION_NUMBER
, STMB.KHR_ID KHR_ID
, CHRB.CONTRACT_NUMBER CONTRACT_NUMBER
FROM OKL_STREAMS STMB
, OKC_K_HEADERS_B CHRB
WHERE STMB.KHR_ID = CHRB.ID
Columns
Name |
TRANSACTION_NUMBER |
KHR_ID |
CONTRACT_NUMBER |