[Home] [Help]
| Product: | OKR - Contracts for Rights (Obsolete) |
|---|---|
| Description: | History view for OKR contract header |
| Implementation/DBA Data: | Not implemented in this database |
SELECT CHBH.ID CHR_ID
, CHBH.CONTRACT_NUMBER CONTRACT_NUMBER
, CHBH.MAJOR_VERSION MAJOR_VERSION
, CHBH.START_DATE START_DATE
, CHBH.END_DATE END_DATE
, OKR_UTIL_PUB.GET_PERIOD_DURATION(CHBH.START_DATE
, CHBH.END_DATE)
, CHBH.ESTIMATED_AMOUNT ESTIMATED_AMOUNT
, CHBH.CURRENCY_CODE CURRENCY_CODE
, CHBH.STS_CODE STS_CODE
, OKR_UTIL_PUB.GET_LU_MEANING('OKC_STATUS_TYPE'
, CHBH.STS_CODE)
, CHBH.SCS_CODE SCS_CODE
, CHBH.AUTHORING_ORG_ID AUTHORING_ORG_ID
, CHBH.BUY_OR_SELL BUY_OR_SELL
, CHBH.TEMPLATE_YN TEMPLATE_YN
, CHBH.DATE_APPROVED DATE_APPROVED
, CHBH.DATE_ISSUED DATE_ISSUED
, CHBH.DATE_SIGNED DATE_SIGNED
, CHBH.DATE_TERMINATED DATE_TERMINATED
, CHBH.DATETIME_CANCELLED DATETIME_CANCELLED
, CHBH.DATE_RENEWED DATE_RENEWED
, CHBH.TRN_CODE TRN_CODE
, OKR_UTIL_PUB.GET_LU_MEANING('OKC_TERMINATION_REASON'
, CHBH.TRN_CODE)
, CHBH.QCL_ID QCL_ID
, CQLT.NAME QCL_CHECKLIST_NAME
, CQLT.SHORT_DESCRIPTION QCL_DESCRIPTION
, CPDT.ID PDF_ID
, CPDT.DESCRIPTION PDF_DESCRIPTION
, CPDT.NAME PDF_NAME
, CPDB.WF_PROCESS_NAME WF_PROCESS_NAME
, CPDB.USAGE PDF_USAGE
, CPBH.ID K_PROCESSES_ID
, CHBH.OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER
, CHBH.CREATED_BY CREATED_BY
, CHBH.CREATION_DATE CREATION_DATE
, CHBH.LAST_UPDATED_BY LAST_UPDATED_BY
, CHBH.LAST_UPDATE_DATE LAST_UPDATE_DATE
, CHBH.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, CHTH.SHORT_DESCRIPTION SHORT_DESCRIPTION
, CHTH.DESCRIPTION DESCRIPTION
, IPYT.IP_ID IP_ID
, IPYT.NAME IP_NAME
, CHBH.TEMPLATE_USED CONTRACT_TYPE_NAME
, CHTH.COMMENTS COMMENTS
FROM OKC_K_HEADERS_TLH CHTH
, OKC_K_ITEMS_H CIMH
, OKC_K_LINES_BH CLBH
, OKC_K_PROCESSES_H CPBH
, OKC_K_HEADERS_BH CHBH
, OKR_IP_COMMON_TL IPYT
, OKC_PROCESS_DEFS_B CPDB
, OKC_PROCESS_DEFS_TL CPDT
, OKC_QA_CHECK_LISTS_TL CQLT
WHERE CHBH.SCS_CODE = 'TDE_RIGHT'
AND CHBH.ID = CHTH.ID
AND CHTH.LANGUAGE = USERENV('LANG')
AND CLBH.CHR_ID = CHBH.ID
AND CLBH.CLE_ID IS NULL
AND CIMH.CLE_ID = CLBH.ID
AND IPYT.LANGUAGE = USERENV('LANG')
AND TO_CHAR(IPYT.IP_ID) = CIMH.OBJECT1_ID1
AND CHBH.QCL_ID = CQLT.ID(+)
AND CHBH.ID = CPBH.CHR_ID(+)
AND CPBH.PDF_ID = CPDB.ID(+)
AND CPDB.ID = CPDT.ID(+)
AND CHBH.MAJOR_VERSION = CHTH.MAJOR_VERSION(+)
AND CHBH.MAJOR_VERSION = CIMH.MAJOR_VERSION(+)
AND CHBH.MAJOR_VERSION = CLBH.MAJOR_VERSION(+)
AND CHBH.MAJOR_VERSION = CPBH.MAJOR_VERSION(+)