VIEW: APPS.OKL_OKS_CONTRACTS_ALL_UV

Source

View Text - Preformatted

SELECT relo.chr_id okl_chr_id, oklh.contract_number, relo.object1_id1 oks_chr_id, okch.contract_number oks_contract_number, (select meaning from fnd_lookup_values_vl where lookup_type='OKL_CONTRACT_CATEGORY' and lookup_code='SERVICE' and view_application_id = 0 ) contract_type, STST.meaning oks_sts_code, okch.start_date oks_start_date, okch.end_date oks_end_date, okch.short_description oks_short_description FROM OKC_K_REL_OBJS_V RELO,OKC_K_HEADERS_ALL_V OKCH,OKC_STATUSES_TL STST,OKL_K_HEADERS_FULL_ALL_V OKLH WHERE rty_code IN ('OKLSRV', 'OKLUBB') AND relo.cle_id IS NULL AND jtot_object1_code = 'OKL_SERVICE' AND okch.STS_CODE = STST.CODE AND STST.LANGUAGE = USERENV('LANG') AND okch.id = relo.object1_id1 AND oklh.id=relo.chr_id

View Text - HTML Formatted

SELECT RELO.CHR_ID OKL_CHR_ID
, OKLH.CONTRACT_NUMBER
, RELO.OBJECT1_ID1 OKS_CHR_ID
, OKCH.CONTRACT_NUMBER OKS_CONTRACT_NUMBER
, (SELECT MEANING
FROM FND_LOOKUP_VALUES_VL
WHERE LOOKUP_TYPE='OKL_CONTRACT_CATEGORY'
AND LOOKUP_CODE='SERVICE'
AND VIEW_APPLICATION_ID = 0 ) CONTRACT_TYPE
, STST.MEANING OKS_STS_CODE
, OKCH.START_DATE OKS_START_DATE
, OKCH.END_DATE OKS_END_DATE
, OKCH.SHORT_DESCRIPTION OKS_SHORT_DESCRIPTION
FROM OKC_K_REL_OBJS_V RELO
, OKC_K_HEADERS_ALL_V OKCH
, OKC_STATUSES_TL STST
, OKL_K_HEADERS_FULL_ALL_V OKLH
WHERE RTY_CODE IN ('OKLSRV'
, 'OKLUBB')
AND RELO.CLE_ID IS NULL
AND JTOT_OBJECT1_CODE = 'OKL_SERVICE'
AND OKCH.STS_CODE = STST.CODE
AND STST.LANGUAGE = USERENV('LANG')
AND OKCH.ID = RELO.OBJECT1_ID1
AND OKLH.ID=RELO.CHR_ID