View: OKL_CTXPRMS_SERCH_UV

Product:	OKL - Lease and Finance Management
Description:
Implementation/DBA Data:	APPS.OKL_CTXPRMS_SERCH_UV

View Text

SELECT CGMB.ID ID
, PMRB.NAME NAME
, PMRTL.DESCRIPTION DESCRIPTION
, CGMB.CGR_ID CGR_ID
, CGMB.PMR_ID PMR_ID
, PMRB.DATATYPE DATATYPE
FROM OKL_CONTEXT_GROUPS_B CGRB
, OKL_CNTX_GRP_PRMTRS CGMB
, OKL_PARAMETERS_B PMRB
, OKL_PARAMETERS_TL PMRTL
WHERE CGRB.ID = CGMB.CGR_ID
AND CGMB.PMR_ID = PMRB.ID
AND PMRB.ID = PMRTL.ID
AND PMRTL.LANGUAGE = USERENV('LANG')

Columns