VIEW: APPS.OKC_KSRCH_REPORT_V

Source

View Text - Preformatted

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

View Text - HTML Formatted

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