Product: | PER - Human Resources |
---|---|
Description: | MLS View based on PER_RI_VIEW_REPORTS table |
Implementation/DBA Data: | APPS.PER_RI_VIEW_REPORTS_VL |
SELECT REP.WORKBENCH_VIEW_REPORT_CODE
, REP_TL.WORKBENCH_VIEW_REPORT_NAME
, REP_TL.WB_VIEW_REPORT_DESCRIPTION
, REP.WORKBENCH_ITEM_CODE
, REP.WORKBENCH_VIEW_REPORT_TYPE
, REP.WORKBENCH_VIEW_REPORT_ACTION
, REP.WORKBENCH_VIEW_COUNTRY
, REP.WB_VIEW_REPORT_INSTRUCTION
, REP.OBJECT_VERSION_NUMBER
, REP.LAST_UPDATE_DATE
, REP.LAST_UPDATED_BY
, REP.LAST_UPDATE_LOGIN
, REP.CREATED_BY
, REP.CREATION_DATE
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')