[Home] [Help]
View: OKC_KOL_CONTACTS_V
| Product: | OKC - Contracts Core |
|---|
| Description: | |
|---|
| Implementation/DBA Data: |
Not implemented in this database
|
|---|
View Text
SELECT CTCB.ID ID
, CTCB.DNZ_CHR_ID DNZ_CHR_ID
, CTCB.CPL_ID
, CTCB.CRO_CODE CRO_CODE
, FNDV.MEANING ROLE
, OKC_UTIL.GET_NAME_FROM_JTFV(CTCB.JTOT_OBJECT1_CODE
, CTCB.OBJECT1_ID1
, CTCB.OBJECT1_ID2) NAME
, CTCB.OBJECT1_ID1
, CTCB.OBJECT1_ID2
, CTCB.JTOT_OBJECT1_CODE
, CTCB.PRIMARY_YN
, CTCB.OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER
, CTCB.CONTACT_SEQUENCE
, CTCB.START_DATE
, CTCB.END_DATE
, SUBSTR(CTCB.CRO_CODE||'*'|| CTCB.JTOT_OBJECT1_CODE
, 1
, 80) KOL_CRO_JTOT_CODE
FROM FND_LOOKUPS FNDV
, OKC_CONTACTS CTCB
WHERE CTCB.CRO_CODE = FNDV.LOOKUP_CODE
AND FNDV.LOOKUP_TYPE = 'OKC_CONTACT_ROLE'
AND SYSDATE BETWEEN FNDV.START_DATE_ACTIVE
AND NVL(FNDV.END_DATE_ACTIVE
, SYSDATE)
Columns
| Name |
| ID |
| DNZ_CHR_ID |
| CPL_ID |
| CRO_CODE |
| ROLE |
| NAME |
| OBJECT1_ID1 |
| OBJECT1_ID2 |
| JTOT_OBJECT1_CODE |
| PRIMARY_YN |
| OBJECT_VERSION_NUMBER |
| CONTACT_SEQUENCE |
| START_DATE |
| END_DATE |
| KOL_CRO_JTOT_CODE |