[Home] [Help]
View: OKC_RG_PARTIES_BLK_HV
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
, RPR.MAJOR_VERSION
FROM OKC_RG_PARTY_ROLES_HV RPR
, OKC_K_PARTY_ROLES_HV CPL
, OKC_RG_ROLE_DEFS_V RRD
WHERE RPR.CPL_ID = CPL.ID
AND RPR.MAJOR_VERSION = CPL.MAJOR_VERSION
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 |
| MAJOR_VERSION |
APPS.OKC_RG_PARTIES_BLK_HV