VIEW: APPS.PER_RI_VIEW_REPORTS_VL

Source

View Text - Preformatted

SELECT rep.WORKBENCH_VIEW_REPORT_CODE WORKBENCH_VIEW_REPORT_CODE, rep_tl.WORKBENCH_VIEW_REPORT_NAME WORKBENCH_VIEW_REPORT_NAME, rep_tl.WB_VIEW_REPORT_DESCRIPTION WB_VIEW_REPORT_DESCRIPTION, rep.WORKBENCH_ITEM_CODE WORKBENCH_ITEM_CODE, rep.WORKBENCH_VIEW_REPORT_TYPE WORKBENCH_VIEW_REPORT_TYPE, rep.WORKBENCH_VIEW_REPORT_ACTION WORKBENCH_VIEW_REPORT_ACTION, rep.WORKBENCH_VIEW_COUNTRY WORKBENCH_VIEW_COUNTRY, rep.WB_VIEW_REPORT_INSTRUCTION WB_VIEW_REPORT_INSTRUCTION, rep.OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER, rep.LAST_UPDATE_DATE LAST_UPDATE_DATE, rep.LAST_UPDATED_BY LAST_UPDATED_BY, rep.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, rep.CREATED_BY CREATED_BY, rep.CREATION_DATE CREATION_DATE, rep.PRIMARY_INDUSTRY PRIMARY_INDUSTRY, rep.ENABLED_FLAG ENABLED_FLAG FROM PER_RI_VIEW_REPORTS REP, PER_RI_VIEW_REPORTS_TL rep_tl where rep.WORKBENCH_VIEW_REPORT_CODE = rep_tl.WORKBENCH_VIEW_REPORT_CODE and rep_tl.LANGUAGE = USERENV('LANG')

View Text - HTML Formatted

SELECT REP.WORKBENCH_VIEW_REPORT_CODE WORKBENCH_VIEW_REPORT_CODE
, REP_TL.WORKBENCH_VIEW_REPORT_NAME WORKBENCH_VIEW_REPORT_NAME
, REP_TL.WB_VIEW_REPORT_DESCRIPTION WB_VIEW_REPORT_DESCRIPTION
, REP.WORKBENCH_ITEM_CODE WORKBENCH_ITEM_CODE
, REP.WORKBENCH_VIEW_REPORT_TYPE WORKBENCH_VIEW_REPORT_TYPE
, REP.WORKBENCH_VIEW_REPORT_ACTION WORKBENCH_VIEW_REPORT_ACTION
, REP.WORKBENCH_VIEW_COUNTRY WORKBENCH_VIEW_COUNTRY
, REP.WB_VIEW_REPORT_INSTRUCTION WB_VIEW_REPORT_INSTRUCTION
, REP.OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER
, REP.LAST_UPDATE_DATE LAST_UPDATE_DATE
, REP.LAST_UPDATED_BY LAST_UPDATED_BY
, REP.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, REP.CREATED_BY CREATED_BY
, REP.CREATION_DATE CREATION_DATE
, REP.PRIMARY_INDUSTRY PRIMARY_INDUSTRY
, REP.ENABLED_FLAG ENABLED_FLAG
FROM PER_RI_VIEW_REPORTS REP
, PER_RI_VIEW_REPORTS_TL REP_TL
WHERE REP.WORKBENCH_VIEW_REPORT_CODE = REP_TL.WORKBENCH_VIEW_REPORT_CODE
AND REP_TL.LANGUAGE = USERENV('LANG')