eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

VIEW: APPS.OKL_CTXPRMS_SERCH_UV

Source

View Text - Preformatted


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')

View Text - HTML Formatted

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')