DBA Data[Home] [Help]

APPS.CZ_RUNTIME dependencies on CZ_ITEM_MASTERS

Line 161: cz_item_masters itm2

157: from cz_ps_nodes psn2,
158: cz_ui_nodes uin,
159: cz_item_property_values ipv2,
160: cz_properties prp2,
161: cz_item_masters itm2
162: where psn2.deleted_flag = '0'
163: and psn2.item_id = ipv2.item_id
164: and ipv2.deleted_flag = '0'
165: and ipv2.property_id = prp2.property_id

Line 181: cz_item_masters itm3,

177: prp3.data_type,psn3.item_id, itm3.item_type_id , prp3.def_value as
178: default_value, uin.ui_node_id
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'

Line 242: cz_item_masters itm2

238: from cz_ps_nodes psn2,
239: cz_ui_nodes uin,
240: cz_item_property_values ipv2,
241: cz_properties prp2,
242: cz_item_masters itm2
243: where psn2.deleted_flag = '0'
244: and psn2.item_id = ipv2.item_id
245: and ipv2.deleted_flag = '0'
246: and ipv2.property_id = prp2.property_id

Line 262: cz_item_masters itm3,

258: prp3.data_type,psn3.item_id, itm3.item_type_id , prp3.def_value as
259: default_value, uin.ui_node_id
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'

Line 333: cz_item_masters itm2

329: from cz_ps_nodes psn2,
330: cz_ui_nodes uin,
331: cz_item_property_values ipv2,
332: cz_properties prp2,
333: cz_item_masters itm2
334: where psn2.deleted_flag = '0'
335: and psn2.item_id = ipv2.item_id
336: and ipv2.deleted_flag = '0'
337: and ipv2.property_id = prp2.property_id

Line 353: cz_item_masters itm3,

349: prp3.data_type,psn3.item_id, itm3.item_type_id , prp3.def_value as
350: default_value, uin.ui_node_id
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'

Line 414: cz_item_masters itm2

410: from cz_ps_nodes psn2,
411: cz_ui_nodes uin,
412: cz_item_property_values ipv2,
413: cz_properties prp2,
414: cz_item_masters itm2
415: where psn2.deleted_flag = '0'
416: and psn2.item_id = ipv2.item_id
417: and ipv2.deleted_flag = '0'
418: and ipv2.property_id = prp2.property_id

Line 434: cz_item_masters itm3,

430: prp3.data_type, psn3.item_id, itm3.item_type_id , prp3.def_value as
431: default_value, uin.ui_node_id
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'