View: OKS_NOTE_SOURCES_V

Product:	OKS - Service Contracts
Description:	View for Service Contract Note Sources.
Implementation/DBA Data:	APPS.OKS_NOTE_SOURCES_V

View Text

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)

Columns