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