VIEW: APPS.OKC_RG_PARTIES_BLK_V

Source

View Text - Preformatted

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

View Text - HTML Formatted

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