View: OKC_REP_DOC_VERSIONS_V

Product:	OKC - Contracts Core
Description:	This view returns repository contract versions
Implementation/DBA Data:	APPS.OKC_REP_DOC_VERSIONS_V

View Text

SELECT RCV.CONTRACT_ID DOCUMENT_ID
, RCV.CONTRACT_TYPE DOCUMENT_TYPE
, RCV.CONTRACT_VERSION_NUM DOCUMENT_VERSION
, RCV.CONTRACT_STATUS_CODE STATUS
, 'Y' ARCHIVED_YN
FROM OKC_REP_CONTRACT_VERS RCV UNION SELECT RCA.CONTRACT_ID DOCUMENT_ID
, RCA.CONTRACT_TYPE DOCUMENT_TYPE
, RCA.CONTRACT_VERSION_NUM DOCUMENT_VERSION
, RCA.CONTRACT_STATUS_CODE STATUS
, 'N' ARCHIVED_YN
FROM OKC_REP_CONTRACTS_ALL RCA

Columns