[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
)IS SELECT meaning
FROM wf_lookups
WHERE lookup_type = b_lookup_type
AND lookup_code = b_lookup_code;
)IS SELECT val.wf_attribute_type attribute_type
, val.text_value attribute_value
FROM jtf_brm_wf_attr_values_v val
, jtf_brm_processes pro
WHERE pro.rule_id = b_rule_id
AND pro.workflow_item_type = b_wf_item_type
AND pro.process_id = val.wf_process_id
AND pro.workflow_item_type = val.wf_item_type
AND pro.workflow_process_name = val.wf_process_name
AND val.wf_process_name = b_wf_process_name
AND val.wf_attribute_name = b_wf_attribute_name;
)IS SELECT wf1.text_default attribute_value
FROM wf_activity_attributes_vl wf1
WHERE wf1.activity_version = (SELECT max(wf2.activity_version)
FROM wf_activity_attributes_vl wf2
WHERE wf2.activity_item_type = wf1.activity_item_type
AND wf2.activity_name = wf1.activity_name
)
AND wf1.activity_item_type = b_wf_item_type
AND wf1.activity_name = b_wf_process_name
AND wf1.name = b_wf_attribute_name;
)IS SELECT val.wf_attribute_type attribute_type
, val.text_value attribute_value
, wlu.meaning attribute_meaning
FROM jtf_brm_wf_attr_values_v val
, jtf_brm_processes pro
, wf_lookups wlu
WHERE pro.rule_id = b_rule_id
AND pro.workflow_item_type = b_wf_item_type
AND pro.process_id = val.wf_process_id
AND pro.workflow_item_type = val.wf_item_type
AND pro.workflow_process_name = val.wf_process_name
AND val.wf_process_name = b_wf_process_name
AND val.wf_attribute_name = b_wf_attribute_name
AND wlu.lookup_type = val.wf_attribute_format
AND wlu.lookup_code = val.text_value
;
)IS SELECT wf1.text_default attribute_value
, wlu.meaning attribute_meaning
FROM wf_activity_attributes_vl wf1
, wf_lookups wlu
WHERE wf1.activity_version = (SELECT max(wf2.activity_version)
FROM wf_activity_attributes_vl wf2
WHERE wf2.activity_item_type = wf1.activity_item_type
AND wf2.activity_name = wf1.activity_name
)
AND wf1.activity_item_type = b_wf_item_type
AND wf1.activity_name = b_wf_process_name
AND wf1.name = b_wf_attribute_name
AND wlu.lookup_type = wf1.format
AND wlu.LOOKUP_CODE = wf1.text_default
;