APPS.EAM_ASSET_LOG_PVT dependencies on CSI_ITEM_INSTANCES

Line 86: FROM mtl_parameters mp, csi_item_instances cii

82: IF p_event_type='EAM_SYSTEM_EVENTS' THEN
83: BEGIN
84: SELECT mp.maint_organization_id, cii.operational_log_flag
85: INTO l_organization_id, l_status
86: FROM mtl_parameters mp, csi_item_instances cii
87: WHERE mp.organization_id = cii.last_vld_organization_id
88: AND cii.instance_id = p_instance_id;
89:
90: IF (l_status = 'N' or l_status is NULL) THEN

Line 385: SELECT instance_id INTO l_status FROM csi_item_instances

381: -- VALIDATION 4 Instance Id
382:
383: IF p_instance_id IS NOT NULL THEN
384: BEGIN
385: SELECT instance_id INTO l_status FROM csi_item_instances
386: WHERE instance_id = p_instance_id;
387:
388: EXCEPTION
389: WHEN NO_DATA_FOUND THEN

Line 593: l_statement := l_statement || ' AND EXISTS (SELECT cii.instance_id FROM csi_item_instances cii WHERE cii.inventory_item_id = '||p_asset_group||' AND cii.instance_id = eal.instance_id)';

589:
590: if p_instance_id is not null then
591: l_statement := l_statement || ' AND instance_id = '||p_instance_id;
592: else
593: l_statement := l_statement || ' AND EXISTS (SELECT cii.instance_id FROM csi_item_instances cii WHERE cii.inventory_item_id = '||p_asset_group||' AND cii.instance_id = eal.instance_id)';
594: end if;
595: else
596: if p_instance_id is not null then
597: l_statement := l_statement || ' AND instance_id = '||p_instance_id ;

Line 702: FROM mtl_parameters mp, csi_item_instances cii

698: x_return_status := FND_API.G_RET_STS_SUCCESS;
699:
700: BEGIN
701: SELECT mp.maint_organization_id INTO l_organization_id
702: FROM mtl_parameters mp, csi_item_instances cii
703: WHERE mp.organization_id = cii.last_vld_organization_id
704: AND cii.instance_id = p_instance_id;
705:
706: EXCEPTION

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 768: from csi_item_instances

764:
765: --start for bug 12894933
766:
767: select location_type_code into l_location_type_code
768: from csi_item_instances
769: where instance_id=p_instance_id;
770:
771:
772: --cpaturing the old Location Name

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:

Line 1223: FROM csi_counter_associations caa, csi_item_instances cii

1219: l_mfg_org_id number;
1220:
1221: CURSOR cmetid IS
1222: SELECT cii.instance_id, cii.instance_number, cii.last_vld_organization_id org_id
1223: FROM csi_counter_associations caa, csi_item_instances cii
1224: WHERE caa.counter_id = p_ref_id AND
1225: cii.instance_id = caa.source_object_id;
1226: BEGIN
1227: -- Standard Start of API savepoint