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 697: FROM mtl_parameters mp, csi_item_instances cii

693: x_return_status := FND_API.G_RET_STS_SUCCESS;
694:
695: BEGIN
696: SELECT mp.maint_organization_id INTO l_organization_id
697: FROM mtl_parameters mp, csi_item_instances cii
698: WHERE mp.organization_id = cii.last_vld_organization_id
699: AND cii.instance_id = p_instance_id;
700:
701: EXCEPTION

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:

Line 879: FROM csi_counter_associations caa, csi_item_instances cii

875: l_mfg_org_id number;
876:
877: CURSOR cmetid IS
878: SELECT cii.instance_id, cii.instance_number, cii.last_vld_organization_id org_id
879: FROM csi_counter_associations caa, csi_item_instances cii
880: WHERE caa.counter_id = p_ref_id AND
881: cii.instance_id = caa.source_object_id;
882: BEGIN
883: -- Standard Start of API savepoint