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: OKO_SALES_TEMPLATES_V

Product:	OKO - Contracts for Sales (Obsolete)
Description:	This view list all sales contract templates.
Implementation/DBA Data:	Not implemented in this database

View Text

SELECT CHR.ID
, CHR.OBJECT_VERSION_NUMBER
, CHR.CONTRACT_NUMBER
, CHR.CONTRACT_NUMBER_MODIFIER
, VER.MAJOR_VERSION
, VER.MINOR_VERSION
, CHR.START_DATE
, CHR.END_DATE
, CHR.STS_CODE
, CHR.SCS_CODE
FROM OKC_K_VERS_NUMBERS VER
, OKC_CLASSES_B CLS
, OKC_K_HEADERS_V CHR
, OKC_SUBCLASSES_B SCS
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)

Columns

Name
ID
OBJECT_VERSION_NUMBER
CONTRACT_NUMBER
CONTRACT_NUMBER_MODIFIER
MAJOR_VERSION
MINOR_VERSION
START_DATE
END_DATE
STS_CODE
SCS_CODE