APPS.AHL_MM_CANNIBALIZATION_PVT dependencies on CSI_ITEM_INSTANCES

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

Line 83: FROM csi_item_instances cis

79: WHERE visit_id = c_visit_id)
80: CONNECT BY cir.object_id = PRIOR cir.subject_id
81: UNION
82: SELECT cis.inventory_item_id
83: FROM csi_item_instances cis
84: WHERE cis.instance_id = c_instance_id;
85:
86:
87: CURSOR get_mc_pos(c_mc_header_id NUMBER, c_position_key NUMBER)