View: OKS_DOCUMENT_VERSIONS_V

Product:	OKS - Service Contracts
Description:	This view is used to provide achived versions of a contract
Implementation/DBA Data:	APPS.OKS_DOCUMENT_VERSIONS_V

View Text

SELECT HDR.ID DOCUMENT_ID
, 'OKS' DOCUMENT_TYPE
, HDR.MAJOR_VERSION
, 'Y' ARCHIVED_YN
FROM OKC_K_HEADERS_BH HDR
, OKC_SUBCLASSES_V SCS
WHERE NOT EXISTS (SELECT 1
FROM OKC_K_VERS_NUMBERS VER
WHERE VER.CHR_ID = HDR.ID
AND VER.MAJOR_VERSION = HDR.MAJOR_VERSION)
AND SCS.CODE = HDR.SCS_CODE
AND SCS.CLS_CODE = 'SERVICE' UNION SELECT VER.CHR_ID DOCUMENT_ID
, 'OKS' DOCUMENT_TYPE
, VER.MAJOR_VERSION
, 'N' ARCHIVED_YN
FROM OKC_K_VERS_NUMBERS VER
, OKC_K_HEADERS_B HDR
, OKC_SUBCLASSES_V SCS
WHERE HDR.ID = VER.CHR_ID
AND SCS.CODE = HDR.SCS_CODE
AND SCS.CLS_CODE = 'SERVICE'

Columns