[Home] [Help]
View: OKL_CONTACT_ROLE_UV
View Text
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)
Columns
Name |
MEANING |
LOOKUP_CODE |
LOOKUP_TYPE |
JTOT_OBJECT_CODE |
RLE_CODE |
BUY_OR_SELL |
CONSTRAINED_YN |