[Home] [Help]
VIEW: APPS.OKL_STM_TRANSACTIONS_UV
Source
View Text - Preformatted
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
View Text - HTML Formatted
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