VIEW: APPS.OKS_CONTRACT_NUMBER_V

Source

View Text - Preformatted

SELECT distinct CHRB.contract_number, CHRT.short_description FROM OKC_K_HEADERS_B CHRB, OKC_K_HEADERS_TL CHRT WHERE CHRB.ID = CHRT.ID and CHRB.scs_code = 'WARRANTY' and CHRT.LANGUAGE = USERENV('LANG')

View Text - HTML Formatted

SELECT DISTINCT CHRB.CONTRACT_NUMBER
, CHRT.SHORT_DESCRIPTION
FROM OKC_K_HEADERS_B CHRB
, OKC_K_HEADERS_TL CHRT
WHERE CHRB.ID = CHRT.ID
AND CHRB.SCS_CODE = 'WARRANTY'
AND CHRT.LANGUAGE = USERENV('LANG')