VIEW: APPS.OKS_NOTE_SOURCES_V

Source

View Text - Preformatted

SELECT top.id service_line_id ,decode(okh.contract_number_modifier,null,okh.contract_number||':'||top.line_number||':'||cov.name,okh.contract_number||':'||okh.contract_number_modifier||':'||top.line_number||':'||cov.name) source_name FROM OKC_K_HEADERS_V OKH,OKC_K_LINES_B TOP,OKC_K_LINES_V COV WHERE okh.id = top.chr_id and top.id = cov.cle_id and cov.lse_id in (2,15,20)

View Text - HTML Formatted

SELECT TOP.ID SERVICE_LINE_ID
, DECODE(OKH.CONTRACT_NUMBER_MODIFIER
, NULL
, OKH.CONTRACT_NUMBER||':'||TOP.LINE_NUMBER||':'||COV.NAME
, OKH.CONTRACT_NUMBER||':'||OKH.CONTRACT_NUMBER_MODIFIER||':'||TOP.LINE_NUMBER||':'||COV.NAME) SOURCE_NAME
FROM OKC_K_HEADERS_V OKH
, OKC_K_LINES_B TOP
, OKC_K_LINES_V COV
WHERE OKH.ID = TOP.CHR_ID
AND TOP.ID = COV.CLE_ID
AND COV.LSE_ID IN (2
, 15
, 20)