VIEW: APPS.OKC_WEB_REPORT_PROF_V

Source

View Text - Preformatted

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

View Text - HTML Formatted

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