eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.CZ_RUNTIME dependencies on CZ_UI_NODES

Line 49: FROM cz_ui_nodes

45: INTO v_ui_features_ref
46: ,v_ui_opt_meth_ref
47: ,v_ui_opt_prop_ref
48: ,v_ui_opt_ord_ref
49: FROM cz_ui_nodes
50: WHERE cz_ui_nodes.ui_def_id = p_ui_def_id
51: AND cz_ui_nodes.deleted_flag = '0'
52: AND cz_ui_nodes.ui_node_type = 148
53: AND cz_ui_nodes.option_sort_method = 2;

Line 50: WHERE cz_ui_nodes.ui_def_id = p_ui_def_id

46: ,v_ui_opt_meth_ref
47: ,v_ui_opt_prop_ref
48: ,v_ui_opt_ord_ref
49: FROM cz_ui_nodes
50: WHERE cz_ui_nodes.ui_def_id = p_ui_def_id
51: AND cz_ui_nodes.deleted_flag = '0'
52: AND cz_ui_nodes.ui_node_type = 148
53: AND cz_ui_nodes.option_sort_method = 2;
54: EXCEPTION

Line 51: AND cz_ui_nodes.deleted_flag = '0'

47: ,v_ui_opt_prop_ref
48: ,v_ui_opt_ord_ref
49: FROM cz_ui_nodes
50: WHERE cz_ui_nodes.ui_def_id = p_ui_def_id
51: AND cz_ui_nodes.deleted_flag = '0'
52: AND cz_ui_nodes.ui_node_type = 148
53: AND cz_ui_nodes.option_sort_method = 2;
54: EXCEPTION
55: WHEN NO_DATA_FOUND THEN

Line 52: AND cz_ui_nodes.ui_node_type = 148

48: ,v_ui_opt_ord_ref
49: FROM cz_ui_nodes
50: WHERE cz_ui_nodes.ui_def_id = p_ui_def_id
51: AND cz_ui_nodes.deleted_flag = '0'
52: AND cz_ui_nodes.ui_node_type = 148
53: AND cz_ui_nodes.option_sort_method = 2;
54: EXCEPTION
55: WHEN NO_DATA_FOUND THEN
56: x_sorted_table.DELETE;

Line 53: AND cz_ui_nodes.option_sort_method = 2;

49: FROM cz_ui_nodes
50: WHERE cz_ui_nodes.ui_def_id = p_ui_def_id
51: AND cz_ui_nodes.deleted_flag = '0'
52: AND cz_ui_nodes.ui_node_type = 148
53: AND cz_ui_nodes.option_sort_method = 2;
54: EXCEPTION
55: WHEN NO_DATA_FOUND THEN
56: x_sorted_table.DELETE;
57: WHEN OTHERS THEN

Line 73: FROM cz_ui_nodes

69: INTO v_ui_features_ref
70: ,v_ui_opt_meth_ref
71: ,v_ui_opt_prop_ref
72: ,v_ui_opt_ord_ref
73: FROM cz_ui_nodes
74: WHERE cz_ui_nodes.ui_def_id = p_ui_def_id
75: AND cz_ui_nodes.deleted_flag = '0'
76: AND cz_ui_nodes.ui_node_type = 148
77: AND cz_ui_nodes.option_sort_method IN (-1, 2);

Line 74: WHERE cz_ui_nodes.ui_def_id = p_ui_def_id

70: ,v_ui_opt_meth_ref
71: ,v_ui_opt_prop_ref
72: ,v_ui_opt_ord_ref
73: FROM cz_ui_nodes
74: WHERE cz_ui_nodes.ui_def_id = p_ui_def_id
75: AND cz_ui_nodes.deleted_flag = '0'
76: AND cz_ui_nodes.ui_node_type = 148
77: AND cz_ui_nodes.option_sort_method IN (-1, 2);
78: EXCEPTION

Line 75: AND cz_ui_nodes.deleted_flag = '0'

71: ,v_ui_opt_prop_ref
72: ,v_ui_opt_ord_ref
73: FROM cz_ui_nodes
74: WHERE cz_ui_nodes.ui_def_id = p_ui_def_id
75: AND cz_ui_nodes.deleted_flag = '0'
76: AND cz_ui_nodes.ui_node_type = 148
77: AND cz_ui_nodes.option_sort_method IN (-1, 2);
78: EXCEPTION
79: WHEN NO_DATA_FOUND THEN

Line 76: AND cz_ui_nodes.ui_node_type = 148

72: ,v_ui_opt_ord_ref
73: FROM cz_ui_nodes
74: WHERE cz_ui_nodes.ui_def_id = p_ui_def_id
75: AND cz_ui_nodes.deleted_flag = '0'
76: AND cz_ui_nodes.ui_node_type = 148
77: AND cz_ui_nodes.option_sort_method IN (-1, 2);
78: EXCEPTION
79: WHEN NO_DATA_FOUND THEN
80: x_sorted_table.DELETE;

Line 77: AND cz_ui_nodes.option_sort_method IN (-1, 2);

73: FROM cz_ui_nodes
74: WHERE cz_ui_nodes.ui_def_id = p_ui_def_id
75: AND cz_ui_nodes.deleted_flag = '0'
76: AND cz_ui_nodes.ui_node_type = 148
77: AND cz_ui_nodes.option_sort_method IN (-1, 2);
78: EXCEPTION
79: WHEN NO_DATA_FOUND THEN
80: x_sorted_table.DELETE;
81: WHEN OTHERS THEN

Line 140: CZ_UI_NODES uin,

136: prp1.data_type, psn1.item_id, to_number (null)
137: as item_type_id, prp1.def_value as default_value, uin.ui_node_id
138: from cz_ps_nodes psn1,
139: cz_ps_prop_vals psp1,
140: CZ_UI_NODES uin,
141: cz_properties prp1
142: where psn1.deleted_flag = '0'
143: and psn1.ps_node_id =psp1.ps_node_id
144: and uin.ps_node_id = psn1.ps_node_id

Line 158: cz_ui_nodes uin,

154: prp2.name as property_name, prp2.property_id,
155: prp2.data_type,psn2.item_id, to_number (null) as item_type_id
156: , prp2.def_value as default_value, uin.ui_node_id
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'

Line 182: cz_ui_nodes uin,

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'
186: and psn3.item_id = itm3.item_id

Line 221: CZ_UI_NODES uin,

217: prp1.data_type,psn1.item_id, to_number (null)
218: as item_type_id, prp1.def_value as default_value, uin.ui_node_id
219: from cz_ps_nodes psn1,
220: cz_ps_prop_vals psp1,
221: CZ_UI_NODES uin,
222: cz_properties prp1
223: where psn1.deleted_flag = '0'
224: and psn1.ps_node_id =psp1.ps_node_id
225: and uin.ps_node_id = psn1.ps_node_id

Line 239: cz_ui_nodes uin,

235: prp2.name as property_name, prp2.property_id,
236: prp2.data_type,psn2.item_id, to_number (null) as item_type_id
237: , prp2.def_value as default_value, uin.ui_node_id
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'

Line 263: cz_ui_nodes uin,

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'
267: and psn3.item_id = itm3.item_id

Line 312: CZ_UI_NODES uin,

308: prp1.data_type,psn1.item_id, to_number (null)
309: as item_type_id, prp1.def_value as default_value, uin.ui_node_id
310: from cz_ps_nodes psn1,
311: cz_ps_prop_vals psp1,
312: CZ_UI_NODES uin,
313: cz_properties prp1
314: where psn1.deleted_flag = '0'
315: and psn1.ps_node_id =psp1.ps_node_id
316: and uin.ps_node_id = psn1.ps_node_id

Line 330: cz_ui_nodes uin,

326: prp2.name as property_name, prp2.property_id,
327: prp2.data_type,psn2.item_id, to_number (null) as item_type_id
328: , prp2.def_value as default_value, uin.ui_node_id
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'

Line 354: cz_ui_nodes uin,

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'
358: and psn3.item_id = itm3.item_id

Line 393: CZ_UI_NODES uin,

389: prp1.data_type, psn1.item_id, to_number (null)
390: as item_type_id, prp1.def_value as default_value, uin.ui_node_id
391: from cz_ps_nodes psn1,
392: cz_ps_prop_vals psp1,
393: CZ_UI_NODES uin,
394: cz_properties prp1
395: where psn1.deleted_flag = '0'
396: and psn1.ps_node_id =psp1.ps_node_id
397: and uin.ps_node_id = psn1.ps_node_id

Line 411: cz_ui_nodes uin,

407: prp2.name as property_name, prp2.property_id,
408: prp2.data_type, psn2.item_id, to_number (null) as item_type_id
409: , prp2.def_value as default_value, uin.ui_node_id
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'

Line 435: cz_ui_nodes uin,

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'
439: and psn3.item_id = itm3.item_id