[Home] [Help]
View: OKS_COVERED_LEVEL_V
Product: | OKS - Service Contracts |
Description: | Covered level view for Contract details form |
Implementation/DBA Data: |
APPS.OKS_COVERED_LEVEL_V
|
View Text
SELECT MTL.NAME
, KL.START_DATE
, KL.END_DATE
, KL.STS_CODE
, KL.DNZ_CHR_ID
FROM OKC_K_LINES_V KL
, OKC_K_ITEMS_V ITEM
, OKC_K_HEADERS_V KH
, OKX_SYSTEM_ITEMS_V MTL
WHERE KL.LSE_ID = 19
AND ITEM.CLE_ID = KL.ID
AND MTL.ID1 = ITEM.OBJECT1_ID1
AND KH.ID = KL.DNZ_CHR_ID
AND KL.CLE_ID IS NULL
AND MTL.ORGANIZATION_ID = KH.INV_ORGANIZATION_ID
Columns
Name |
NAME |
START_DATE |
END_DATE |
STS_CODE |
DNZ_CHR_ID |