APPS.EAM_ASSET_LOG_PVT dependencies on CSI_ITEM_INSTANCES_H

Line 727: FROM csi_item_instances_H

723: l_status := null;
724: IF p_event_type='EAM_SYSTEM_EVENTS' THEN
725: BEGIN
726: SELECT instance_history_id INTO l_status
727: FROM csi_item_instances_H
728: WHERE instance_history_id = p_ref_id
729: AND (nvl(old_location_id,1) <> nvl(new_location_id,1));
730:
731: EXCEPTION

Line 738: FROM csi_item_instances_h

734: END;
735:
736: BEGIN
737: SELECT instance_history_id INTO l_status1
738: FROM csi_item_instances_h
739: WHERE instance_history_id = p_ref_id AND
740: old_active_end_date IS NULL and
741: new_active_end_date IS NOT NULL;
742: EXCEPTION

Line 749: FROM csi_item_instances_h

745: END;
746:
747: BEGIN
748: SELECT instance_history_id INTO l_status2
749: FROM csi_item_instances_h
750: WHERE instance_history_id = p_ref_id AND
751: old_active_end_date is not null
752: AND new_active_end_date IS NULL;
753: EXCEPTION

Line 762: FROM csi_item_instances_H

758: IF l_status IS NOT NULL THEN
759: l_event_id := 13 ;
760:
761: /*SELECT old_location_id||'->'||new_location_id INTO l_reference
762: FROM csi_item_instances_H
763: WHERE instance_history_id = p_ref_id; */ --commented for bug 12894933
764:
765: --start for bug 12894933
766:

Line 927: FROM csi_item_instances_H ciih

923: FROM hz_locations hz
924: WHERE
925: hz.location_id = ciih.old_location_id),
926: NULL) INTO l_old_loc_name
927: FROM csi_item_instances_H ciih
928: WHERE instance_history_id = p_ref_id;
929:
930: --capturing the new location Name
931:

Line 1085: FROM csi_item_instances_H ciih

1081: FROM hz_locations hz
1082: WHERE
1083: hz.location_id = ciih.new_location_id),
1084: NULL) INTO l_new_loc_name
1085: FROM csi_item_instances_H ciih
1086: WHERE instance_history_id = p_ref_id;
1087:
1088: --Now capturing the new and old location names after cutting down the length to the Reference Field
1089: if(l_old_loc_name is not null and length(l_old_loc_name) > 32) then

Line 1108: FROM csi_item_instances_h

1104: ELSIF l_status1 IS NOT NULL THEN
1105: l_event_id := 2 ;
1106:
1107: SELECT to_char(last_updated_by) INTO l_reference
1108: FROM csi_item_instances_h
1109: WHERE instance_history_id = p_ref_id;
1110:
1111: ELSIF l_status2 IS NOT NULL THEN
1112: l_event_id := 1 ;

Line 1115: FROM csi_item_instances_H

1111: ELSIF l_status2 IS NOT NULL THEN
1112: l_event_id := 1 ;
1113:
1114: SELECT to_char(last_updated_by) INTO l_reference
1115: FROM csi_item_instances_H
1116: WHERE instance_history_id = p_ref_id;
1117:
1118: END IF;
1119: