View: OKC_SALES_TEMPLATES_V

Product:	OKC - Contracts Core
Description:
Implementation/DBA Data:	APPS.OKC_SALES_TEMPLATES_V

View Text

SELECT CHR.ID
, CHR.OBJECT_VERSION_NUMBER
, CHR.CONTRACT_NUMBER
, CHR.CONTRACT_NUMBER_MODIFIER
, VER.MAJOR_VERSION
, VER.MINOR_VERSION
, OSV.MEANING STATUS
, CHR.SHORT_DESCRIPTION
, CHR.DESCRIPTION
, CHR.START_DATE
, CHR.END_DATE
, CHR.DATE_APPROVED
, CHR.DATE_SIGNED
, CHR.DATETIME_CANCELLED
, CHR.DATE_TERMINATED
, CHR.STS_CODE USER_STATUS_CODE
, CHR.SCS_CODE
, OSV.STE_CODE SYSTEM_STATUS_CODE
, CHR.AUTHORING_ORG_ID
FROM OKC_STATUSES_V OSV
, OKC_SUBCLASSES_B SCS
, OKC_K_HEADERS_V CHR
, OKC_CLASSES_B CLS
, OKC_K_VERS_NUMBERS VER
WHERE CHR.TEMPLATE_YN = 'Y'
AND CHR.BUY_OR_SELL = 'S'
AND CHR.ISSUE_OR_RECEIVE = 'I'
AND CHR.ID = VER.CHR_ID
AND CLS.CODE ='SALES'
AND CHR.SCS_CODE = SCS.CODE
AND SCS.CLS_CODE = CLS.CODE
AND SYSDATE >= NVL(CHR.START_DATE
, SYSDATE)
AND SYSDATE <= NVL(CHR.END_DATE
, SYSDATE)
AND SYSDATE <= NVL(CHR.DATE_TERMINATED
, SYSDATE)
AND CHR.STS_CODE =OSV.CODE

Columns