DBA Data[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