View: OKS_APPROVED_CONTRACTS_V

Product:	OKS - Service Contracts
Description:	View for Approved Contracts
Implementation/DBA Data:	APPS.OKS_APPROVED_CONTRACTS_V

View Text

SELECT NKITM.OBJECT1_ID1 CUSTOMER_PRODUCT_ID
, SVCKLINE.START_DATE START_DATE
, SVCKLINE.END_DATE END_DATE
, NHDR.CONTRACT_NUMBER CONTRACT_NUMBER
, NHDR.CONTRACT_NUMBER_MODIFIER CONTRACT_NUMBER_MODIFIER
, NHDR.ID CONTRACT_ID
FROM OKC_K_ITEMS NKITM
, OKC_K_LINES_B SVCKLINE
, OKC_K_LINES_B CLVLLINE
, OKC_K_HEADERS_B NHDR
WHERE NHDR.ID = SVCKLINE.DNZ_CHR_ID
AND SVCKLINE.STS_CODE IN('SIGNED'
, 'ACTIVE')
AND SVCKLINE.ID = CLVLLINE.CLE_ID
AND CLVLLINE.LSE_ID = 25
AND CLVLLINE.ID = NKITM.CLE_ID
AND NKITM.JTOT_OBJECT1_CODE = 'OKX_CUSTPROD'

Columns