VIEW: APPS.OKC_SALES_TEMPLATES_V

Source

View Text - Preformatted

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

View Text - HTML Formatted

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