View: OKC_RG_PARTIES_LOV_V

Product:	OKC - Contracts Core
Description:
Implementation/DBA Data:	APPS.OKC_RG_PARTIES_LOV_V

View Text

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

Columns