DBA Data[Home] [Help]

VIEW: APPS.WF_ITEM_TYPES_VL

Source

View Text - Preformatted

SELECT B.ROWID ROW_ID, B.NAME, B.PROTECT_LEVEL, B.CUSTOM_LEVEL, B.WF_SELECTOR, B.READ_ROLE, B.WRITE_ROLE, B.EXECUTE_ROLE, B.PERSISTENCE_TYPE, B.PERSISTENCE_DAYS, T.DISPLAY_NAME, T.DESCRIPTION from WF_ITEM_TYPES B, WF_ITEM_TYPES_TL T WHERE B.NAME = T.NAME and T.LANGUAGE = userenv('LANG')
View Text - HTML Formatted

SELECT B.ROWID ROW_ID
, B.NAME
, B.PROTECT_LEVEL
, B.CUSTOM_LEVEL
, B.WF_SELECTOR
, B.READ_ROLE
, B.WRITE_ROLE
, B.EXECUTE_ROLE
, B.PERSISTENCE_TYPE
, B.PERSISTENCE_DAYS
, T.DISPLAY_NAME
, T.DESCRIPTION
FROM WF_ITEM_TYPES B
, WF_ITEM_TYPES_TL T
WHERE B.NAME = T.NAME
AND T.LANGUAGE = USERENV('LANG')