DBA Data[Home] [Help]

VIEW: APPS.BIS_RSS_PORTLETS_VL

Source

View Text - Preformatted

SELECT
        rp.PORTLET_SHORT_NAME,
        rpt.NAME,
        rpt.DESCRIPTION,
        rp.XML_URL,
        rp.XSL_URL,
        rp.CREATED_BY,
        rp.CREATION_DATE,
        rp.LAST_UPDATED_BY,
        rp.LAST_UPDATE_DATE,
        rp.LAST_UPDATE_LOGIN,
        rp.parameters
 FROM
        BIS_RSS_PORTLETS rp,
        BIS_RSS_PORTLETS_TL rpt
 WHERE
        rp.PORTLET_SHORT_NAME = rpt. PORTLET_SHORT_NAME AND
        rpt.LANGUAGE = USERENV('LANG') 

View Text - HTML Formatted

SELECT RP.PORTLET_SHORT_NAME
, RPT.NAME
, RPT.DESCRIPTION
, RP.XML_URL
, RP.XSL_URL
, RP.CREATED_BY
, RP.CREATION_DATE
, RP.LAST_UPDATED_BY
, RP.LAST_UPDATE_DATE
, RP.LAST_UPDATE_LOGIN
, RP.PARAMETERS FROM BIS_RSS_PORTLETS RP
, BIS_RSS_PORTLETS_TL RPT WHERE RP.PORTLET_SHORT_NAME = RPT. PORTLET_SHORT_NAME AND RPT.LANGUAGE = USERENV('LANG')