VIEW: APPS.WF_ITEM_ATTR_VALUES_ONDEMAND

Source

View Text - Preformatted

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
        )

   

View Text - HTML Formatted

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 )