DBA Data[Home] [Help]

APPS.WF_CLONE dependencies on WF_ITEM_ATTRIBUTES

Line 43: from WF_ITEM_ATTRIBUTES wia

39: set wiav.text_value =
40: replace(wiav.text_value,source_web_agent,target_web_agent)
41: where (wiav.item_type, wiav.name) =
42: (select wia.item_type, wia.name
43: from WF_ITEM_ATTRIBUTES wia
44: where wia.type = 'URL'
45: and wia.item_type = wiav.item_type
46: and wia.name = wiav.name)
47: and wiav.text_value is not null

Line 52: update WF_ITEM_ATTRIBUTES

48: and instr(wiav.text_value,source_web_agent) > 0 ;
49:
50:
51: --For default item attribute values
52: update WF_ITEM_ATTRIBUTES
53: set text_default = replace(text_default,source_web_agent,target_web_agent)
54: where type ='URL'
55: and text_default is not null
56: and instr(text_default,source_web_agent) > 0 ;