DBA Data[Home] [Help]

APPS.CSI_CZ_INT dependencies on CSI_II_RELATIONSHIPS

Line 224: FROM csi_ii_relationships cir,

220: /* replaced the cursor for 3892929
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'

Line 244: FROM csi_ii_relationships cir,

240: decode (subject_id, instance_id, config_inst_hdr_id, -9999) sub_inst_hdr_id,
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'