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'