[Home] [Help]
View: WF_ACTIVITY_ATTRIBUTES_VL
Product: | FND - Application Object Library |
Description: | View of WF_ACTIVITY_ATTRIBUTES and WF_ACTIVITY_ATTRIBUTES_TL |
Implementation/DBA Data: |
APPS.WF_ACTIVITY_ATTRIBUTES_VL
|
View Text
SELECT B.ROWID ROW_ID
, B.ACTIVITY_ITEM_TYPE
, B.ACTIVITY_NAME
, B.ACTIVITY_VERSION
, B.NAME
, B.SEQUENCE
, B.TYPE
, B.VALUE_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_ACTIVITY_ATTRIBUTES B
, WF_ACTIVITY_ATTRIBUTES_TL T
WHERE B.ACTIVITY_ITEM_TYPE = T.ACTIVITY_ITEM_TYPE
AND B.ACTIVITY_NAME = T.ACTIVITY_NAME
AND B.ACTIVITY_VERSION = T.ACTIVITY_VERSION
AND B.NAME = T.NAME
AND T.LANGUAGE = USERENV('LANG')
Columns
Name |
ROW_ID |
ACTIVITY_ITEM_TYPE |
ACTIVITY_NAME |
ACTIVITY_VERSION |
NAME |
SEQUENCE |
TYPE |
VALUE_TYPE |
PROTECT_LEVEL |
CUSTOM_LEVEL |
SUBTYPE |
FORMAT |
TEXT_DEFAULT |
NUMBER_DEFAULT |
DATE_DEFAULT |
DISPLAY_NAME |
DESCRIPTION |