[Home] [Help]
View: OKC_RG_PARTIES_BLK_V
View Text
SELECT RPR.RGP_ID
, RPR.DNZ_CHR_ID
, RRD.SUBJECT_OBJECT_FLAG
, RPR.ID
, RPR.OBJECT_VERSION_NUMBER
, RPR.CPL_ID
, RPR.RRD_ID
, RPR.CREATED_BY
, RPR.CREATION_DATE
, RPR.LAST_UPDATED_BY
, RPR.LAST_UPDATE_DATE
, RPR.LAST_UPDATE_LOGIN
, DECODE(RRD.OPTIONAL_YN
, 'Y'
, 'N'
, 'Y') REQUIRED_YN
, CPL.ROLE
, SUBSTRB(OKC_RULE_PUB.GET_OBJECT_VAL( CPL.JTOT_OBJECT1_CODE
, CPL.OBJECT1_ID1
, CPL.OBJECT1_ID2)
, 1
, 450) PARTY
FROM OKC_RG_PARTY_ROLES_V RPR
, OKC_K_PARTY_ROLES_V CPL
, OKC_RG_ROLE_DEFS_V RRD
WHERE RPR.CPL_ID = CPL.ID
AND RPR.RRD_ID = RRD.ID
Columns
Name |
RGP_ID |
DNZ_CHR_ID |
SUBJECT_OBJECT_FLAG |
ID |
OBJECT_VERSION_NUMBER |
CPL_ID |
RRD_ID |
CREATED_BY |
CREATION_DATE |
LAST_UPDATED_BY |
LAST_UPDATE_DATE |
LAST_UPDATE_LOGIN |
REQUIRED_YN |
ROLE |
PARTY |