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.

VIEW: APPS.OKL_STRMS_STD_HDR_UV

Source

View Text - Preformatted


SELECT CKRV.ID KHR_ID, CKRV.CURRENCY_CODE CURRENCY_CODE, CKRV.CONTRACT_NUMBER CONTRACT_NUMBER, CKRV.SHORT_DESCRIPTION SHORT_DESCRIPTION, OXPV.NAME CUST_NAME, STST.MEANING STATUS FROM OKC_K_HEADERS_V CKRV,OKX_PARTIES_V OXPV,OKC_K_PARTY_ROLES_V CPLV,OKC_STATUSES_TL STST WHERE CKRV.ID = CPLV.CHR_ID AND CPLV.RLE_CODE = 'LESSEE' AND CPLV.OBJECT1_ID1 = OXPV.ID1 AND CPLV.OBJECT1_ID2 = OXPV.ID2 AND CKRV.STS_CODE = STST.CODE AND STST.LANGUAGE = USERENV('LANG')

View Text - HTML Formatted

SELECT CKRV.ID KHR_ID
, CKRV.CURRENCY_CODE CURRENCY_CODE
, CKRV.CONTRACT_NUMBER CONTRACT_NUMBER
, CKRV.SHORT_DESCRIPTION SHORT_DESCRIPTION
, OXPV.NAME CUST_NAME
, STST.MEANING STATUS
FROM OKC_K_HEADERS_V CKRV
, OKX_PARTIES_V OXPV
, OKC_K_PARTY_ROLES_V CPLV
, OKC_STATUSES_TL STST
WHERE CKRV.ID = CPLV.CHR_ID
AND CPLV.RLE_CODE = 'LESSEE'
AND CPLV.OBJECT1_ID1 = OXPV.ID1
AND CPLV.OBJECT1_ID2 = OXPV.ID2
AND CKRV.STS_CODE = STST.CODE
AND STST.LANGUAGE = USERENV('LANG')