APPS.AHL_MM_CANNIBALIZATION_PVT dependencies on CSI_II_RELATIONSHIPS

Line 72: FROM csi_item_instances cis, csi_ii_relationships cir

68:
69: CURSOR get_supply_inst_details(c_visit_id NUMBER,c_instance_id NUMBER)
70: IS
71: SELECT cis.inventory_item_id
72: FROM csi_item_instances cis, csi_ii_relationships cir
73: WHERE cis.instance_id = cir.subject_id
74: AND cir.relationship_type_code = 'COMPONENT-OF'
75: AND cis.instance_id = c_instance_id
76: AND NVL(cir.active_end_date,sysdate) >= sysdate