SELECT *
  FROM wf_item_activity_statuses wias, wf_process_activities wpa
  WHERE wias.process_activity = wpa.instance_id
-- AND   wpa.activity_name = 'PURCHASE RELEASE ELIGIBLE'
  AND   wias.item_type = 'OEOL'
  AND   wias.item_key  = to_char(2369510) -- order line id
-- AND   wias.activity_status = 'NOTIFIED';

arrow
arrow
    全站熱搜

    Somebaby 發表在 痞客邦 留言(0) 人氣()