VIEW: APPS.OKC_RG_PARTIES_LOV_V

Source

View Text - Preformatted

SELECT cpl.DNZ_CHR_ID dnz_chr_id ,cpl.cle_id cle_id ,srd.rgd_code ,rrd.SUBJECT_OBJECT_FLAG ,cpl.ROLE ,decode(rrd.OPTIONAL_YN,'Y','','*') required_star ,substrb(OKC_RULE_PUB.get_object_val( cpl.JTOT_OBJECT1_CODE ,cpl.OBJECT1_ID1 ,cpl.OBJECT1_ID2),1,450) party ,cpl.ID CPL_ID ,rrd.id RRD_ID from okc_k_party_roles_v cpl ,okc_k_headers_b chr ,OKC_SUBCLASS_ROLES_V sre ,OKC_SUBCLASS_RG_DEFS_V srd ,OKC_RG_ROLE_DEFS_v rrd WHERE cpl.DNZ_CHR_ID = chr.id and chr.SCS_CODE = sre.SCS_CODE and cpl.RLE_CODE = sre.RLE_CODE and sysdate between sre.START_DATE and nvl(sre.END_DATE,sysdate)+1 and chr.SCS_CODE = srd.SCS_CODE and sysdate between srd.START_DATE and nvl(srd.END_DATE,sysdate)+1 and rrd.SRD_ID = srd.ID and rrd.SRE_ID = sre.ID

View Text - HTML Formatted

SELECT CPL.DNZ_CHR_ID DNZ_CHR_ID
, CPL.CLE_ID CLE_ID
, SRD.RGD_CODE
, RRD.SUBJECT_OBJECT_FLAG
, CPL.ROLE
, DECODE(RRD.OPTIONAL_YN
, 'Y'
, ''
, '*') REQUIRED_STAR
, SUBSTRB(OKC_RULE_PUB.GET_OBJECT_VAL( CPL.JTOT_OBJECT1_CODE
, CPL.OBJECT1_ID1
, CPL.OBJECT1_ID2)
, 1
, 450) PARTY
, CPL.ID CPL_ID
, RRD.ID RRD_ID
FROM OKC_K_PARTY_ROLES_V CPL
, OKC_K_HEADERS_B CHR
, OKC_SUBCLASS_ROLES_V SRE
, OKC_SUBCLASS_RG_DEFS_V SRD
, OKC_RG_ROLE_DEFS_V RRD
WHERE CPL.DNZ_CHR_ID = CHR.ID
AND CHR.SCS_CODE = SRE.SCS_CODE
AND CPL.RLE_CODE = SRE.RLE_CODE
AND SYSDATE BETWEEN SRE.START_DATE
AND NVL(SRE.END_DATE
, SYSDATE)+1
AND CHR.SCS_CODE = SRD.SCS_CODE
AND SYSDATE BETWEEN SRD.START_DATE
AND NVL(SRD.END_DATE
, SYSDATE)+1
AND RRD.SRD_ID = SRD.ID
AND RRD.SRE_ID = SRE.ID