View: PER_RI_WORKBENCH_ITEMS_VL

Product:	PER - Human Resources
Description:	MLS view based on PER_RI_WORKBENCH_ITEMS table
Implementation/DBA Data:	APPS.PER_RI_WORKBENCH_ITEMS_VL

View Text

SELECT ITM.WORKBENCH_ITEM_CODE
, ITM_TL.WORKBENCH_ITEM_NAME
, ITM_TL.WORKBENCH_ITEM_DESCRIPTION
, ITM.WORKBENCH_ITEM_SEQUENCE
, ITM.WORKBENCH_PARENT_ITEM_CODE
, ITM.WORKBENCH_ITEM_CREATION_DATE
, ITM.WORKBENCH_ITEM_TYPE
, ITM.MENU_ID
, ITM.OBJECT_VERSION_NUMBER
, ITM.LAST_UPDATE_DATE
, ITM.LAST_UPDATED_BY
, ITM.LAST_UPDATE_LOGIN
, ITM.CREATED_BY
, ITM.CREATION_DATE
FROM PER_RI_WORKBENCH_ITEMS ITM
, PER_RI_WORKBENCH_ITEMS_TL ITM_TL
WHERE ITM.WORKBENCH_ITEM_CODE = ITM_TL.WORKBENCH_ITEM_CODE
AND ITM_TL.LANGUAGE = USERENV('LANG')

Columns