eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

View: OKI_RENEW_RELS_V

Product:	OKI - Contracts Intelligence (Obsolete)
Description:	This view relates renewed and renewing contracts and contract lines.
Implementation/DBA Data:	Not implemented in this database

View Text

SELECT SCHR.ID
, SCHR.STS_CODE
, SSTS1.STE_CODE
, SCLE.ID
, SCLE.STS_CODE
, SSTS2.STE_CODE
, TCHR.ID
, TCHR.STS_CODE
, TSTS1.STE_CODE
, TCLE.ID
, TCLE.STS_CODE
, TSTS2.STE_CODE
FROM OKC_CLASS_OPERATIONS COP
, OKC_K_HEADERS_B TCHR
, OKC_K_LINES_B TCLE
, OKC_OPERATION_INSTANCES OIE
, OKC_OPERATION_LINES OLE
, OKC_K_HEADERS_B SCHR
, OKC_K_LINES_B SCLE
, OKC_STATUSES_B TSTS1
, OKC_STATUSES_B TSTS2
, OKC_STATUSES_B SSTS1
, OKC_STATUSES_B SSTS2
WHERE COP.OPN_CODE IN ('RENEWAL'
, 'REN_CON')
AND COP.ID = OIE.COP_ID
AND OLE.PROCESS_FLAG = 'P'
AND OLE.OIE_ID = OIE.ID
AND TCHR.ID = OLE.SUBJECT_CHR_ID
AND TCLE.ID = OLE.SUBJECT_CLE_ID
AND TSTS1.CODE = TCHR.STS_CODE
AND TSTS2.CODE = TCLE.STS_CODE
AND SCHR.ID = OLE.OBJECT_CHR_ID
AND SCLE.ID = OLE.OBJECT_CLE_ID
AND SSTS1.CODE = SCHR.STS_CODE
AND SSTS2.CODE = SCLE.STS_CODE

Columns

Name
SOURCE_HEADER_ID
SOURCE_CHR_STATUS_CODE
SOURCE_CHR_STATUS_TYPE
SOURCE_LINE_ID
SOURCE_CLE_STATUS_CODE
SOURCE_CLE_STATUS_TYPE
TRGT_HEADER_ID
TRGT_CHR_STATUS_CODE
TRGT_CHR_STATUS_TYPE
TRGT_LINE_ID
TRGT_CLE_STATUS_CODE
TRGT_CLE_STATUS_TYPE