View: OKC_WEB_REPORT_PROF_V

Product:	OKC - Contracts Core
Description:	Used to set OKC_WEB_REPORT profile option
Implementation/DBA Data:	APPS.OKC_WEB_REPORT_PROF_V

View Text

SELECT XST.ID
, XSL.NAME||':'||DECODE(XST.CACHE_YN
, 'Y'
, 'CACHE'
, 'NOCACHE')||'->' ||SQL.NAME VALUE
FROM OKC_REPORT_SQL_V SQL
, OKC_REPORT_XST_V XST
, OKC_REPORT_XSL_V XSL
WHERE XST.XSL_ID = XSL.ID
AND XST.SQL_ID = SQL.ID UNION ALL SELECT XST.ID
, XSL.NAME||':'||DECODE(XST.CACHE_YN
, 'Y'
, 'CACHE'
, 'NOCACHE')||'->' ||XSL1.NAME VALUE
FROM OKC_REPORT_XST_V XST
, OKC_REPORT_XSL_V XSL
, OKC_REPORT_XST_V XST1
, OKC_REPORT_XSL_V XSL1
WHERE XST.XSL_ID = XSL.ID
AND XST.XST_ID = XST1.ID
AND XST1.XSL_ID = XSL1.ID

Columns