[Home] [Help]
View: OKC_KOL_PARTY_ROLES_V
| Product: | OKC - Contracts Core |
|---|
| Description: | |
|---|
| Implementation/DBA Data: |
Not implemented in this database
|
|---|
View Text
SELECT CPLB.ID
, OKC_UTIL.GET_NAME_FROM_JTFV(CPLB.JTOT_OBJECT1_CODE
, CPLB.OBJECT1_ID1
, CPLB.OBJECT1_ID2)
, CPLT.COGNOMEN
, CPLB.CHR_ID
, CPLB.DNZ_CHR_ID
, CPLB.RLE_CODE
, FNDV.MEANING
, CPLB.OBJECT1_ID1
, CPLB.OBJECT1_ID2
, CPLB.JTOT_OBJECT1_CODE
, CPLB.OBJECT_VERSION_NUMBER
, CPLT.SFWT_FLAG
, CPLB.RLE_CODE||'*'||CPLB.JTOT_OBJECT1_CODE KOL_RLE_JTOT_CODE
, CPLB.PRIMARY_YN
FROM FND_LOOKUPS FNDV
, OKC_K_PARTY_ROLES_B CPLB
, OKC_K_PARTY_ROLES_TL CPLT
WHERE CPLB.ID = CPLT.ID
AND CPLT.LANGUAGE = USERENV('LANG')
AND FNDV.LOOKUP_TYPE = 'OKC_ROLE'
AND SYSDATE BETWEEN FNDV.START_DATE_ACTIVE
AND NVL(FNDV.END_DATE_ACTIVE
, SYSDATE)
AND CPLB.RLE_CODE = FNDV.LOOKUP_CODE
Columns
| Name |
| ID |
| NAME |
| KNOWN_AS |
| CHR_ID |
| DNZ_CHR_ID |
| RLE_CODE |
| ROLE |
| OBJECT1_ID1 |
| OBJECT1_ID2 |
| JTOT_OBJECT1_CODE |
| OBJECT_VERSION_NUMBER |
| SFWT_FLAG |
| KOL_RLE_JTOT_CODE |
| PRIMARY_YN |