View: OKL_PARTY_ROLE_UV

Product:	OKL - Lease and Finance Management
Description:
Implementation/DBA Data:	APPS.OKL_PARTY_ROLE_UV

View Text

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')))

Columns