VIEW: APPS.OKL_PARTY_ROLE_UV

Source

View Text - Preformatted

SELECT OKL_ACCOUNTING_UTIL.get_lookup_meaning('OKC_ROLE', rscv.rle_code, 510, 0) MEANING, rscv.rle_code LOOKUP_CODE, rscv.jtot_object_code JTOT_OBJECT_CODE, 'OKC_ROLE' LOOKUP_TYPE, srev.scs_code SCS_CODE, rscv.buy_or_sell BUY_OR_SELL FROM OKC_SUBCLASS_ROLES SREV,OKC_ROLE_SOURCES RSCV WHERE rscv.rle_code = srev.rle_code AND SYSDATE BETWEEN rscv.START_DATE AND NVL(rscv.END_DATE,SYSDATE) AND SYSDATE BETWEEN srev.START_DATE AND NVL(srev.END_DATE,SYSDATE) AND (SREV.ACCESS_LEVEL = 'S' OR (SREV.ACCESS_LEVEL = 'U' AND RSCV.JTOT_OBJECT_CODE IN ('OKX_PARTY','OKX_VENDOR','OKX_OPERUNIT')))

View Text - HTML Formatted

SELECT OKL_ACCOUNTING_UTIL.GET_LOOKUP_MEANING('OKC_ROLE'
, RSCV.RLE_CODE
, 510
, 0) MEANING
, RSCV.RLE_CODE LOOKUP_CODE
, RSCV.JTOT_OBJECT_CODE JTOT_OBJECT_CODE
, 'OKC_ROLE' LOOKUP_TYPE
, SREV.SCS_CODE SCS_CODE
, RSCV.BUY_OR_SELL BUY_OR_SELL
FROM OKC_SUBCLASS_ROLES SREV
, OKC_ROLE_SOURCES RSCV
WHERE RSCV.RLE_CODE = SREV.RLE_CODE
AND SYSDATE BETWEEN RSCV.START_DATE
AND NVL(RSCV.END_DATE
, SYSDATE)
AND SYSDATE BETWEEN SREV.START_DATE
AND NVL(SREV.END_DATE
, SYSDATE)
AND (SREV.ACCESS_LEVEL = 'S' OR (SREV.ACCESS_LEVEL = 'U'
AND RSCV.JTOT_OBJECT_CODE IN ('OKX_PARTY'
, 'OKX_VENDOR'
, 'OKX_OPERUNIT')))