View: OKS_PRODUCTS_V

Product:	OKS - Service Contracts
Description:	View is Used for Contracts Quote Printing
Implementation/DBA Data:	APPS.OKS_PRODUCTS_V

View Text

SELECT L.START_DATE
, L.END_DATE
, L.DNZ_CHR_ID CONTRACT_ID
, L.CLE_ID LINE_ID
, L.ID PRODUCT_LINE_ID
, L.LSE_ID
, LS.NAME
, IT.OBJECT1_ID1
, IT.NUMBER_OF_ITEMS
, IT.UOM_CODE
, L.PRICE_NEGOTIATED
FROM OKC_K_HEADERS_V K
, OKC_K_LINES_V L
, OKC_LINE_STYLES_V LS
, OKC_K_ITEMS_V IT
WHERE K.ID = L.DNZ_CHR_ID
AND L.LSE_ID IN (11
, 25
, 35)
AND L.LSE_ID = LS.ID
AND L.ID = IT.CLE_ID

Columns