eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

VIEW: APPS.OKS_COVDLEVEL_DETAILS_V

Source

View Text - Preformatted


SELECT SRV.LINE_NUMBER||'.'||KLIN.LINE_NUMBER CONCATENATED_LINE_NUMBER ,KLIN.LINE_NUMBER ,LSE.NAME ,KLIN.LSE_ID ,KLIN.COGNOMEN ,KLIN.START_DATE ,KLIN.END_DATE ,KLIN.STS_CODE ,KLIN.PRICE_NEGOTIATED ,KLIN.ID ,KLIN.CHR_ID ,KLIN.DNZ_CHR_ID ,KLIN.CLE_ID FROM OKC_K_LINES_B SRV ,OKC_K_LINES_V KLIN ,OKC_LINE_STYLES_V LSE WHERE SRV.ID = KLIN.CLE_ID AND SRV.CLE_ID IS NULL AND LSE.ID = KLIN.LSE_ID AND KLIN.LSE_ID IN(7,8,9,10,11,18,25,35)

View Text - HTML Formatted

SELECT SRV.LINE_NUMBER||'.'||KLIN.LINE_NUMBER CONCATENATED_LINE_NUMBER
, KLIN.LINE_NUMBER
, LSE.NAME
, KLIN.LSE_ID
, KLIN.COGNOMEN
, KLIN.START_DATE
, KLIN.END_DATE
, KLIN.STS_CODE
, KLIN.PRICE_NEGOTIATED
, KLIN.ID
, KLIN.CHR_ID
, KLIN.DNZ_CHR_ID
, KLIN.CLE_ID
FROM OKC_K_LINES_B SRV
, OKC_K_LINES_V KLIN
, OKC_LINE_STYLES_V LSE
WHERE SRV.ID = KLIN.CLE_ID
AND SRV.CLE_ID IS NULL
AND LSE.ID = KLIN.LSE_ID
AND KLIN.LSE_ID IN(7
, 8
, 9
, 10
, 11
, 18
, 25
, 35)