Product: | OKR - Contracts for Rights (Obsolete) |
---|---|
Description: | |
Implementation/DBA Data: | Not implemented in this database |
SELECT CHRB.ID CHR_ID
, CHRB.CONTRACT_NUMBER CONTRACT_NUMBER
, OKR_UTIL_PUB.GET_VERSION_NUMBER(CHRB.ID)
, CHRB.START_DATE START_DATE
, CHRB.END_DATE END_DATE
, OKR_UTIL_PUB.GET_PERIOD_DURATION(CHRB.START_DATE
, CHRB.END_DATE)
, CHRB.ESTIMATED_AMOUNT ESTIMATED_AMOUNT
, CHRB.CURRENCY_CODE CURRENCY_CODE
, CHRB.STS_CODE STS_CODE
, OKR_UTIL_PUB.GET_K_STATUS_MEANING(CHRB.STS_CODE)
, CHRB.SCS_CODE SCS_CODE
, CHRB.AUTHORING_ORG_ID AUTHORING_ORG_ID
, CHRB.BUY_OR_SELL BUY_OR_SELL
, CHRB.TEMPLATE_YN TEMPLATE_YN
, CHRB.DATE_APPROVED DATE_APPROVED
, CHRB.DATE_ISSUED DATE_ISSUED
, CHRB.DATE_SIGNED DATE_SIGNED
, CHRB.DATE_TERMINATED DATE_TERMINATED
, CHRB.DATETIME_CANCELLED DATETIME_CANCELLED
, CHRB.DATE_RENEWED DATE_RENEWED
, CHRB.TRN_CODE TRN_CODE
, OKR_UTIL_PUB.GET_LU_MEANING('OKC_TERMINATION_REASON'
, CHRB.TRN_CODE)
, CHRB.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
, CPSB.ID K_PROCESSES_ID
, CHRB.OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER
, CHRB.CREATED_BY CREATED_BY
, CHRB.CREATION_DATE CREATION_DATE
, CHRB.LAST_UPDATED_BY LAST_UPDATED_BY
, CHRB.LAST_UPDATE_DATE LAST_UPDATE_DATE
, CHRB.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, CHRT.SHORT_DESCRIPTION SHORT_DESCRIPTION
, CHRT.DESCRIPTION DESCRIPTION
, CHRB.TEMPLATE_USED CONTRACT_TYPE_NAME
, CHRT.COMMENTS COMMENTS
FROM OKC_PROCESS_DEFS_B CPDB
, OKC_K_HEADERS_B CHRB
, OKC_K_HEADERS_TL CHRT
, OKC_PROCESS_DEFS_TL CPDT
, OKC_K_PROCESSES CPSB
, OKC_QA_CHECK_LISTS_TL CQLT
WHERE CHRB.SCS_CODE = 'TDE_RIGHT'
AND CHRB.ID = CHRT.ID
AND CHRT.LANGUAGE = USERENV('LANG')
AND CHRB.QCL_ID = CQLT.ID(+)
AND CHRB.ID = CPSB.CHR_ID(+)
AND CPSB.PDF_ID = CPDB.ID(+)
AND CPDB.ID = CPDT.ID(+)