DBA Data[Home] [Help]

APPS.IES_META_DATA_UPDATER dependencies on IES_META_PROPERTIES

Line 128: ies_meta_properties b,

124: CURSOR getPropertiesForObject IS
125: SELECT b.name, c.propval_id , b.property_id
126: FROM ies_meta_objects o,
127: ies_meta_object_propvals a,
128: ies_meta_properties b,
129: ies_meta_property_values c
130: WHERE o.object_uid = uid
131: AND a.propval_id = c.propval_id
132: AND b.property_id = c.property_id

Line 222: ies_meta_properties b

218:
219: OPEN props FOR
220: 'SELECT b.name, a.property_id
221: FROM ies_meta_obj_type_properties a,
222: ies_meta_properties b
223: WHERE a.property_id = b.property_id
224: AND a.objtype_id IN (SELECT type_id
225: FROM ies_meta_object_types
226: CONNECT BY PRIOR parent_id = type_id

Line 233: ies_meta_properties b,

229: WHERE object_uid = :aUID))
230: AND b.property_id NOT IN (SELECT b.property_id
231: FROM ies_meta_objects o,
232: ies_meta_object_propvals a,
233: ies_meta_properties b,
234: ies_meta_property_values c
235: WHERE o.object_uid = :bUID
236: AND a.propval_id = c.propval_id
237: AND b.property_id = c.property_id