179: from
180: cz_ps_nodes psn3,
181: cz_item_masters itm3,
182: cz_ui_nodes uin,
183: cz_item_type_properties itp3,
184: cz_properties prp3
185: where psn3.deleted_flag = '0'
186: and psn3.item_id = itm3.item_id
187: and itm3.deleted_flag = '0'
260: from
261: cz_ps_nodes psn3,
262: cz_item_masters itm3,
263: cz_ui_nodes uin,
264: cz_item_type_properties itp3,
265: cz_properties prp3
266: where psn3.deleted_flag = '0'
267: and psn3.item_id = itm3.item_id
268: and itm3.deleted_flag = '0'
351: from
352: cz_ps_nodes psn3,
353: cz_item_masters itm3,
354: cz_ui_nodes uin,
355: cz_item_type_properties itp3,
356: cz_properties prp3
357: where psn3.deleted_flag = '0'
358: and psn3.item_id = itm3.item_id
359: and itm3.deleted_flag = '0'
432: from
433: cz_ps_nodes psn3,
434: cz_item_masters itm3,
435: cz_ui_nodes uin,
436: cz_item_type_properties itp3,
437: cz_properties prp3
438: where psn3.deleted_flag = '0'
439: and psn3.item_id = itm3.item_id
440: and itm3.deleted_flag = '0'