[Home] [Help]
View: OKS_COVDLEVEL_DETAILS_V
Product: | OKS - Service Contracts |
Description: | This view is used to show the service details of a contract. This included all covered levels. |
Implementation/DBA Data: |
APPS.OKS_COVDLEVEL_DETAILS_V
|
View Text
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)
Columns
Name |
CONCATENATED_LINE_NUMBER |
LINE_NUMBER |
LINE_TYPE |
LSE_ID |
LINE_REF |
LINE_START_DATE |
LINE_END_DATE |
LINE_STATUS |
LINE_AMOUNT |
ID |
CHR_ID |
DNZ_CHR_ID |
CLE_ID |