[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
'SELECT a.name key,
NVL(b.string_val, d.lookup_key) value,
e.type_name
FROM ies_meta_properties a,
ies_meta_property_values b,
ies_meta_object_propvals c,
ies_meta_property_lookups d,
ies_meta_prop_datatypes e
WHERE c.object_id = :object_Id
AND c.propval_id = b.propval_id
AND b.property_id = a.property_id
AND a.datatype_id = e.type_id
AND b.lookup_id = d.prop_lookup_id (+)' USING objId;
'SELECT a.object_id object_id,
a.name name,
b.type_name type_name,
a.object_uid obj_uid
FROM ies_meta_objects a,
ies_meta_object_types b
WHERE a.object_id = :obj_id
AND a.type_id = b.type_id' using objId;
' SELECT a.secondary_obj_id, c.type_name, c.list_relationship
FROM ies_meta_obj_relationships a,
ies_meta_obj_relationships b,
ies_meta_relationship_types c
WHERE a.deleted_status = 0
AND a.primary_obj_id = :object_id
AND a.primary_obj_id <> b.secondary_obj_id
AND a.objrel_id = b.objrel_id
AND a.type_id = c.type_id
ORDER BY a.obj_order, a.secondary_obj_id' using objId;