View: JTF_BRM_WF_ATTR_V

Product:	JTF - CRM Foundation
Description:	View used for the business rule workbench form.
Implementation/DBA Data:	APPS.JTF_BRM_WF_ATTR_V

View Text

SELECT WAL.ROWID ROW_ID
, JBS.WF_ATTR_VALUE_ID WF_ATTR_VALUE_ID
, JBS.PROCESS_ID WF_PROCESS_ID
, WAL.ACTIVITY_ITEM_TYPE WF_ITEM_TYPE
, WAL.ACTIVITY_NAME WF_PROCESS_NAME
, WAL.ACTIVITY_VERSION WF_PROCESS_VERSION
, WAL.NAME WF_ATTRIBUTE_NAME
, WAL.DISPLAY_NAME WF_ATTRIBUTE_DISPLAY_NAME
, WAL.DESCRIPTION WF_ATTRIBUTE_DESCRIPTION
, WAL.TYPE WF_ATTRIBUTE_TYPE
, WAL.FORMAT WF_ATTRIBUTE_FORMAT
, JTF_BRM_UTILITY_PVT.ATTRIBUTE_FORMAT( WAL.TYPE
, NVL(JBS.TEXT_VALUE
, WAL.TEXT_DEFAULT)
, NVL(JBS.NUMBER_VALUE
, WAL.NUMBER_DEFAULT)
, NVL(JBS.DATE_VALUE
, WAL.DATE_DEFAULT)
, WAL.FORMAT ) WF_ATTRIBUTE_VALUE
, JBS.TEXT_VALUE
, JBS.NUMBER_VALUE
, JBS.DATE_VALUE
FROM JTF_BRM_WF_ATTR_VALUES JBS
, ( SELECT WF1.ACTIVITY_ITEM_TYPE
, WF1.ACTIVITY_NAME
, WF1.NAME
, WF1.DISPLAY_NAME
, WF1.DESCRIPTION
, WF1.TYPE
, WF1.FORMAT
, WF1.ACTIVITY_VERSION
, WF1.TEXT_DEFAULT
, WF1.NUMBER_DEFAULT
, WF1.DATE_DEFAULT
FROM WF_ACTIVITY_ATTRIBUTES_VL WF1
WHERE WF1.ACTIVITY_VERSION = ( SELECT MAX(WF2.ACTIVITY_VERSION)
FROM WF_ACTIVITY_ATTRIBUTES_VL WF2
WHERE WF2.ACTIVITY_ITEM_TYPE = WF1.ACTIVITY_ITEM_TYPE
AND WF2.ACTIVITY_NAME = WF1.ACTIVITY_NAME ) ) WAL
, ( SELECT LOOKUP_CODE BRM_WF_ITEM_TYPE
FROM FND_LOOKUP_VALUES
WHERE LOOKUP_TYPE = 'JTF_BRM_WF_ITEM_TYPE'
AND LANGUAGE = USERENV('LANG') )LIT
WHERE JBS.WF_ITEM_TYPE = WAL.ACTIVITY_ITEM_TYPE
AND JBS.WF_ACTIVITY_NAME = WAL.ACTIVITY_NAME
AND JBS.WF_ACTIVITY_VERSION = WAL.ACTIVITY_VERSION
AND JBS.WF_ACTIVITY_ATTRIBUTE_NAME = WAL.NAME
AND LIT.BRM_WF_ITEM_TYPE = WAL.ACTIVITY_ITEM_TYPE UNION ALL SELECT WAL.ROWID ROW_ID
, TO_NUMBER(NULL) WF_ATTR_VALUE_ID
, TO_NUMBER(NULL) WF_PROCESS_ID
, WAL.ACTIVITY_ITEM_TYPE WF_ITEM_TYPE
, WAL.ACTIVITY_NAME WF_PROCESS_NAME
, WAL.ACTIVITY_VERSION WF_PROCESS_VERSION
, WAL.NAME WF_ATTRIBUTE_NAME
, WAL.DISPLAY_NAME WF_ATTRIBUTE_DISPLAY_NAME
, WAL.DESCRIPTION WF_ATTRIBUTE_DESCRIPTION
, WAL.TYPE WF_ATTRIBUTE_TYPE
, WAL.FORMAT WF_ATTRIBUTE_FORMAT
, JTF_BRM_UTILITY_PVT.ATTRIBUTE_FORMAT( WAL.TYPE
, WAL.TEXT_DEFAULT
, WAL.NUMBER_DEFAULT
, WAL.DATE_DEFAULT
, WAL.FORMAT ) WF_ATTRIBUTE_VALUE
, TO_CHAR(NULL) TEXT_VALUE
, TO_NUMBER(NULL) NUMBER_VALUE
, TO_DATE(NULL) DATE_VALUE FROM( SELECT WF1.ACTIVITY_ITEM_TYPE
, WF1.ACTIVITY_NAME
, WF1.NAME
, WF1.DISPLAY_NAME
, WF1.DESCRIPTION
, WF1.TYPE
, WF1.FORMAT
, WF1.ACTIVITY_VERSION
, WF1.TEXT_DEFAULT
, WF1.NUMBER_DEFAULT
, WF1.DATE_DEFAULT
FROM WF_ACTIVITY_ATTRIBUTES_VL WF1
WHERE WF1.ACTIVITY_VERSION = ( SELECT MAX(WF2.ACTIVITY_VERSION)
FROM WF_ACTIVITY_ATTRIBUTES_VL WF2
WHERE WF2.ACTIVITY_ITEM_TYPE = WF1.ACTIVITY_ITEM_TYPE
AND WF2.ACTIVITY_NAME = WF1.ACTIVITY_NAME ) ) WAL
, ( SELECT LOOKUP_CODE BRM_WF_ITEM_TYPE
FROM FND_LOOKUP_VALUES
WHERE LOOKUP_TYPE = 'JTF_BRM_WF_ITEM_TYPE'
AND LANGUAGE = USERENV('LANG') )LIT
WHERE LIT.BRM_WF_ITEM_TYPE = WAL.ACTIVITY_ITEM_TYPE

Columns