SELECT /* $HEADER: WF_ITEM_ATTR_VALUES_ONDEMAND.XDF 120.0 2005/09/30 09:43:01 ANPWANG NOSHIP $ */
ITEM_TYPE ,
ITEM_KEY ,
NAME ,
TEXT_VALUE ,
NUMBER_VALUE ,
DATE_VALUE ,
EVENT_VALUE
FROM WF_ITEM_ATTRIBUTE_VALUES
UNION ALL
SELECT
I.ITEM_TYPE ,
I.ITEM_KEY ,
A.NAME ,
A.TEXT_DEFAULT ,
A.NUMBER_DEFAULT ,
A.DATE_DEFAULT ,
NULL
FROM WF_ITEMS I , WF_ITEM_ATTRIBUTES A
WHERE
I.ITEM_TYPE = A.ITEM_TYPE
AND NOT EXISTS
(
SELECT NULL FROM
WF_ITEM_ATTRIBUTE_VALUES V
WHERE V.ITEM_TYPE = I.ITEM_TYPE
AND V.ITEM_KEY = I.ITEM_KEY
AND V.NAME = A.NAME
)