View: OKS_K_DETAIL_V

Product:	OKS - Service Contracts
Description:	view for contracts detail form
Implementation/DBA Data:	APPS.OKS_K_DETAIL_V

View Text

SELECT KH.CONTRACT_NUMBER CONTRACT_NUMBER
, KH.START_DATE START_DATE
, KH.END_DATE END_DATE
, KD.ID ID
, KD.ORDER_LINE_ID1 ORDER_LINE_ID1
, KD.CHR_ID CHR_ID
, KD.CLE_ID CLE_ID
, KD.OBJECT_VERSION_NUMBER
FROM OKC_K_HEADERS_V KH
, OKS_K_ORDER_DETAILS_V KD
WHERE KD.LINK_CHR_ID = KH.ID

Columns