APPS.CSI_CZ_INT dependencies on CZ_CONFIG_ITEMS

Line 45: cz_config_items czItems

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
49: AND czItems.config_item_id = cii.config_inst_item_id

Line 90: FROM cz_config_items czItems

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
90: FROM cz_config_items czItems
91: WHERE czItems.instance_hdr_id = p_config_header_id
92: AND czItems.instance_rev_nbr = cii.config_inst_rev_num
93: AND czItems.config_item_id = cii.config_inst_item_id
94: AND czItems.component_instance_type = 'I' -- I = Root instance

Line 409: FROM cz_config_items czItems

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'
409: FROM cz_config_items czItems
410: WHERE czItems.instance_hdr_id = l_conn_hdr_id
411: AND czItems.instance_rev_nbr = cii.config_inst_rev_num
412: AND czItems.config_item_id = cii.config_inst_item_id
413: AND czItems.component_instance_type = 'I' -- I = Root instance

Line 1730: cz_config_items_v c

1726: Begin
1727: Select count(*)
1728: Into l_found
1729: From csi_item_instances i,
1730: cz_config_items_v c
1731: Where i.config_inst_hdr_id = c.instance_hdr_id
1732: and i.config_inst_rev_num = c.instance_rev_nbr
1733: and i.config_inst_item_id = c.config_item_id
1734: and c.config_hdr_id = p_config_hdr_id