[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 |