[Home] [Help]
View: OKC_KSRCH_REPORT_V
View Text
SELECT CHRV.CONTRACT_NUMBER CONTRACT_NUMBER
, CHRV.CONTRACT_NUMBER_MODIFIER MODIFIER
, KVER.MAJOR_VERSION||'.'||KVER.MINOR_VERSION VERSION
, SC.MEANING CATEGORY
, CHRT.DESCRIPTION DESCRIPTION
, CHRV.START_DATE START_DATE
, CHRV.END_DATE END_DATE
, STS.MEANING STATUS
, CHRV.DATE_APPROVED APPROVED
, CHRV.DATE_SIGNED SIGNED
, CHRV.DATE_TERMINATED TERMINATED
, CHRV.DATE_RENEWED RENEWED
, CHRV.DATETIME_CANCELLED CANCELLED
, CHRV.CURRENCY_CODE CURRENCY
, CHRV.ESTIMATED_AMOUNT AMOUNT
, CHRT.COGNOMEN KNOWN_AS
, KEXP.REPORT_ID REPORT_ID
, KVER.LAST_UPDATE_DATE LAST_UPDATED_DATE
FROM OKC_K_HEADERS_B CHRV
, OKC_K_HEADERS_TL CHRT
, OKC_STATUSES_TL STS
, OKC_SUBCLASSES_TL SC
, OKC_KEXP_REPORT KEXP
, OKC_K_VERS_NUMBERS KVER
WHERE CHRV.ID = CHRT.ID
AND CHRT.LANGUAGE = USERENV('LANG')
AND STS.CODE = CHRV.STS_CODE
AND STS.LANGUAGE = USERENV('LANG')
AND SC.CODE = CHRV.SCS_CODE
AND SC.LANGUAGE = USERENV('LANG')
AND CHRV.ROWID = KEXP.CONTRACT_HEADER_ROWID
AND CHRV.ID = KVER.CHR_ID
Columns
| Name |
| CONTRACT_NUMBER |
| MODIFIER |
| VERSION |
| CATEGORY |
| DESCRIPTION |
| START_DATE |
| END_DATE |
| STATUS |
| APPROVED |
| SIGNED |
| TERMINATED |
| RENEWED |
| CANCELLED |
| CURRENCY |
| AMOUNT |
| KNOWN_AS |
| REPORT_ID |
| LAST_UPDATE_DATE |
APPS.OKC_KSRCH_REPORT_V