APPS.EAM_ASSET_LOG_PVT dependencies on CSI_ITEM_INSTANCES_H

Line 722: FROM csi_item_instances_H

718: l_status := null;
719: IF p_event_type='EAM_SYSTEM_EVENTS' THEN
720: BEGIN
721: SELECT instance_history_id INTO l_status
722: FROM csi_item_instances_H
723: WHERE instance_history_id = p_ref_id
724: AND (nvl(old_location_id,1) <> nvl(new_location_id,1));
725:
726: EXCEPTION

Line 733: FROM csi_item_instances_h

729: END;
730:
731: BEGIN
732: SELECT instance_history_id INTO l_status1
733: FROM csi_item_instances_h
734: WHERE instance_history_id = p_ref_id AND
735: old_active_end_date IS NULL and
736: new_active_end_date IS NOT NULL;
737: EXCEPTION

Line 744: FROM csi_item_instances_h

740: END;
741:
742: BEGIN
743: SELECT instance_history_id INTO l_status2
744: FROM csi_item_instances_h
745: WHERE instance_history_id = p_ref_id AND
746: old_active_end_date is not null
747: AND new_active_end_date IS NULL;
748: EXCEPTION

Line 757: FROM csi_item_instances_H

753: IF l_status IS NOT NULL THEN
754: l_event_id := 13 ;
755:
756: SELECT old_location_id||'->'||new_location_id INTO l_reference
757: FROM csi_item_instances_H
758: WHERE instance_history_id = p_ref_id;
759:
760: ELSIF l_status1 IS NOT NULL THEN
761: l_event_id := 2 ;

Line 764: FROM csi_item_instances_h

760: ELSIF l_status1 IS NOT NULL THEN
761: l_event_id := 2 ;
762:
763: SELECT to_char(last_updated_by) INTO l_reference
764: FROM csi_item_instances_h
765: WHERE instance_history_id = p_ref_id;
766:
767: ELSIF l_status2 IS NOT NULL THEN
768: l_event_id := 1 ;

Line 771: FROM csi_item_instances_H

767: ELSIF l_status2 IS NOT NULL THEN
768: l_event_id := 1 ;
769:
770: SELECT to_char(last_updated_by) INTO l_reference
771: FROM csi_item_instances_H
772: WHERE instance_history_id = p_ref_id;
773:
774: END IF;
775: