APPS.CSI_CZ_INT dependencies on CSI_ITEM_INSTANCES

Line 37: -- FROM csi_item_instances cii

33: as suggested by CZ */
34:
35: -- CURSOR installed_cur(p_inst_hdr_id in number) IS
36: -- SELECT cii.config_inst_rev_num
37: -- FROM csi_item_instances cii
38: -- WHERE cii.config_inst_hdr_id = p_inst_hdr_id
39: -- AND sysdate BETWEEN nvl(cii.active_start_date, sysdate-1)
40: -- AND nvl(cii.active_end_date, sysdate+1);
41: /* Changes for bug 3901123 . Commented this cursor to replace with a single select - Performance

Line 44: FROM csi_item_instances cii,

40: -- AND nvl(cii.active_end_date, sysdate+1);
41: /* Changes for bug 3901123 . Commented this cursor to replace with a single select - Performance
42: CURSOR installed_cur(p_inst_hdr_id in number) IS
43: SELECT cii.config_inst_rev_num
44: FROM csi_item_instances cii,
45: cz_config_items czItems
46: WHERE cii.config_inst_hdr_id = p_inst_hdr_id
47: AND czItems.instance_hdr_id = p_inst_hdr_id
48: AND czItems.component_instance_type in ('I','R') -- I = Root instance

Line 85: FROM csi_item_instances cii

81: cii.config_inst_item_id
82: INTO x_install_config_rec.config_inst_hdr_id,
83: x_install_config_rec.config_inst_rev_num,
84: x_install_config_rec.config_inst_item_id
85: FROM csi_item_instances cii
86: WHERE cii.config_inst_hdr_id = p_config_header_id
87: AND sysdate BETWEEN nvl(cii.active_start_date, sysdate-1)
88: AND nvl(cii.active_end_date, sysdate+1)
89: AND EXISTS (SELECT 'Y' -- bug 3901123

Line 225: csi_item_instances cii

221: CURSOR installed_cur(p_inst_hdr_id in number, p_inst_rev_num in number) IS
222: SELECT subject_id,
223: object_id
224: FROM csi_ii_relationships cir,
225: csi_item_instances cii
226: WHERE cii.config_inst_hdr_id = p_inst_hdr_id
227: AND cii.config_inst_rev_num = p_inst_rev_num
228: AND cir.relationship_type_code = 'CONNECTED-TO'
229: AND ( cir.subject_id = cii.instance_id

Line 245: csi_item_instances cii

241: decode (object_id, instance_id, config_inst_hdr_id, -9999) obj_inst_hdr_id,
242: config_inst_item_id,
243: config_inst_rev_num
244: FROM csi_ii_relationships cir,
245: csi_item_instances cii
246: WHERE cii.config_inst_hdr_id = p_inst_hdr_id
247: AND cii.config_inst_rev_num = p_inst_rev_num
248: AND cir.relationship_type_code = 'CONNECTED-TO'
249: AND ( cir.subject_id = cii.instance_id

Line 307: FROM csi_item_instances

303: config_inst_item_id
304: INTO l_sub_hdr_id,
305: l_sub_rev_num,
306: l_sub_item_id
307: FROM csi_item_instances
308: WHERE instance_id = installed_rec.subject_id
309: AND sysdate BETWEEN nvl(active_start_date, sysdate-1)
310: AND nvl(active_end_date, sysdate+1);
311: EXCEPTION

Line 323: FROM csi_item_instances

319: config_inst_item_id
320: INTO l_obj_hdr_id,
321: l_obj_rev_num,
322: l_obj_item_id
323: FROM csi_item_instances
324: WHERE instance_id = installed_rec.object_id
325: AND sysdate BETWEEN nvl(active_start_date, sysdate-1)
326: AND nvl(active_end_date, sysdate+1);
327: EXCEPTION

Line 364: FROM csi_item_instances

360: config_inst_item_id
361: INTO l_sub_hdr_id,
362: l_sub_rev_num,
363: l_sub_item_id
364: FROM csi_item_instances
365: WHERE instance_id = installed_rec.subject_id
366: AND sysdate BETWEEN nvl(active_start_date, sysdate-1)
367: AND nvl(active_end_date, sysdate+1);
368: l_conn_hdr_id := l_sub_hdr_id; -- the connected instance hdr ID

Line 384: FROM csi_item_instances

380: config_inst_item_id
381: INTO l_obj_hdr_id,
382: l_obj_rev_num,
383: l_obj_item_id
384: FROM csi_item_instances
385: WHERE instance_id = installed_rec.object_id
386: AND sysdate BETWEEN nvl(active_start_date, sysdate-1)
387: AND nvl(active_end_date, sysdate+1);
388: l_conn_hdr_id := l_obj_hdr_id; -- the connected instance hdr ID

Line 404: FROM csi_item_instances cii

400: cii.config_inst_item_id
401: INTO l_root_hdr_id,
402: l_root_rev_num,
403: l_root_item_id
404: FROM csi_item_instances cii
405: WHERE cii.config_inst_hdr_id = l_conn_hdr_id
406: AND sysdate BETWEEN nvl(cii.active_start_date, sysdate-1)
407: AND nvl(cii.active_end_date, sysdate+1)
408: AND EXISTS (SELECT 'Y'

Line 718: FROM CSI_ITEM_INSTANCES

714: -- THEN
715: BEGIN
716: SELECT instance_id
717: INTO l_config_tbl(l_child_ind).instance_id
718: FROM CSI_ITEM_INSTANCES
719: WHERE CONFIG_INST_HDR_ID = l_config_rec.config_inst_hdr_id
720: -- AND CONFIG_INST_REV_NUM = l_config_rec.config_inst_rev_num
721: AND CONFIG_INST_ITEM_ID = l_config_rec.config_inst_item_id;
722:

Line 1688: From csi_item_instances i,

1684: THEN
1685: Begin
1686: Select count(*)
1687: Into l_found
1688: From csi_item_instances i,
1689: cz_config_items_v c
1690: Where i.config_inst_hdr_id = c.instance_hdr_id
1691: and i.config_inst_rev_num = c.instance_rev_nbr
1692: and i.config_inst_item_id = c.config_item_id