DBA Data[Home] [Help]

VIEW: APPS.WF_ITEM_ATTRIBUTES_VL

Source

View Text - Preformatted

SELECT B.ROWID ROW_ID , B.ITEM_TYPE , B.NAME , B.SEQUENCE , B.TYPE , B.PROTECT_LEVEL , B.CUSTOM_LEVEL , B.SUBTYPE , B.FORMAT , B.TEXT_DEFAULT , B.NUMBER_DEFAULT , B.DATE_DEFAULT , T.DISPLAY_NAME , T.DESCRIPTION FROM WF_ITEM_ATTRIBUTES B, WF_ITEM_ATTRIBUTES_TL T WHERE B.ITEM_TYPE = T.ITEM_TYPE AND B.NAME = T.NAME AND T.LANGUAGE = USERENV('LANG')
View Text - HTML Formatted

SELECT B.ROWID ROW_ID
, B.ITEM_TYPE
, B.NAME
, B.SEQUENCE
, B.TYPE
, B.PROTECT_LEVEL
, B.CUSTOM_LEVEL
, B.SUBTYPE
, B.FORMAT
, B.TEXT_DEFAULT
, B.NUMBER_DEFAULT
, B.DATE_DEFAULT
, T.DISPLAY_NAME
, T.DESCRIPTION
FROM WF_ITEM_ATTRIBUTES B
, WF_ITEM_ATTRIBUTES_TL T
WHERE B.ITEM_TYPE = T.ITEM_TYPE
AND B.NAME = T.NAME
AND T.LANGUAGE = USERENV('LANG')