VIEW: APPS.OKL_CONTACT_ROLE_UV

Source

View Text - Preformatted

SELECT OKL_ACCOUNTING_UTIL.get_lookup_meaning('OKC_CONTACT_ROLE',B.cro_code,510,0) MEANING, B.cro_code LOOKUP_CODE, 'OKC_CONTACT_ROLE' LOOKUP_TYPE, B.jtot_object_code JTOT_OBJECT_CODE, B.rle_code RLE_CODE, B.buy_or_sell BUY_OR_SELL, B.constrained_yn CONSTRAINED_YN FROM OKC_CONTACT_SOURCES B WHERE SYSDATE >= B.start_date AND(B.end_date IS NULL OR B.end_date >= SYSDATE)

View Text - HTML Formatted

SELECT OKL_ACCOUNTING_UTIL.GET_LOOKUP_MEANING('OKC_CONTACT_ROLE'
, B.CRO_CODE
, 510
, 0) MEANING
, B.CRO_CODE LOOKUP_CODE
, 'OKC_CONTACT_ROLE' LOOKUP_TYPE
, B.JTOT_OBJECT_CODE JTOT_OBJECT_CODE
, B.RLE_CODE RLE_CODE
, B.BUY_OR_SELL BUY_OR_SELL
, B.CONSTRAINED_YN CONSTRAINED_YN
FROM OKC_CONTACT_SOURCES B
WHERE SYSDATE >= B.START_DATE AND(B.END_DATE IS NULL OR B.END_DATE >= SYSDATE)