[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
select nvl(notification_id,0), nvl(process_activity,0)
from wf_item_activity_statuses
where item_type = itype
and item_key = ikey
and activity_status='NOTIFIED'
order by begin_date desc, execution_time desc;
select NA.text_value
into attribute_value
from WF_NOTIFICATION_ATTRIBUTES NA,
WF_MESSAGE_ATTRIBUTES_VL MA,
WF_NOTIFICATIONS N
where N.NOTIFICATION_ID = ntf_id
and NA.NOTIFICATION_ID = N.NOTIFICATION_ID
and MA.MESSAGE_NAME = N.MESSAGE_NAME
and MA.MESSAGE_TYPE = N.MESSAGE_TYPE
and MA.NAME = NA.NAME
and MA.SUBTYPE = 'RESPOND'
and MA.TYPE <> 'FORM'
and MA.NAME <> 'RESULT';
select wv.text_value
into attribute_value
from wf_process_activities wpa,
wf_activities wa,
wf_activity_attributes waa,
wf_activity_attr_values wv,
wf_items wi
where wpa.instance_id = frm_id
and wpa.activity_item_type = wa.item_type
and wpa.activity_name = wa.name
and waa.activity_item_type = wa.item_type
and waa.activity_name = wa.name
and waa.activity_version = wa.version
and wv.process_activity_id = wpa.instance_id
and wv.name = waa.name
and waa.type = 'FORM'
and wi.item_type = wf_item_type
and wi.begin_date >= wa.begin_date
and wi.begin_date < nvl(wa.end_date,wi.begin_date+1)
and wi.item_key = wf_item_key;