APPS.EAM_ASSETATTR_VALUE_PUB dependencies on CSI_ITEM_INSTANCES

Line 106: FROM mtl_system_items MSI , csi_item_instances CII

102: IF (p_maintenance_object_type = 3) THEN
103: IF ( p_serial_number IS NOT NULL ) THEN
104:
105: SELECT count(*) INTO l_count_rec
106: FROM mtl_system_items MSI , csi_item_instances CII
107: WHERE cii.serial_number = p_serial_number
108: AND cii.instance_id = p_maintenance_object_id
109: AND CII.inventory_item_id = MSI.inventory_item_id
110: AND MSI.inventory_item_id = p_asset_group_id;

Line 166: from csi_item_instances

162:
163: if p_eam_item_type = 1
164: then
165: select count(*) into l_count
166: from csi_item_instances
167: where instance_id=p_object_id;
168: elsif p_eam_item_type = 2
169: then
170: select count(*) into l_count

Line 560: from mtl_system_items msi, csi_item_instances cii

556:
557: ELSE
558: begin
559: select msi.eam_item_type into l_item_type
560: from mtl_system_items msi, csi_item_instances cii
561: where cii.inventory_item_id = msi.inventory_item_id
562: and cii.last_vld_organization_id = msi.organization_id
563: and cii.instance_id = p_maintenance_object_id;
564:

Line 591: from csi_item_instances

587: and p_maintenance_object_id IS NULL ) THEN
588:
589: begin
590: select instance_id, 3 into l_maintenance_object_id, l_maintenance_object_type
591: from csi_item_instances
592: where serial_number = p_serial_number
593: and inventory_item_id = p_inventory_item_id;
594:
595: exception when no_data_found then

Line 606: from csi_item_instances cii

602:
603: begin
604: select cii.serial_number, cii.inventory_item_id
605: into l_serial_number, l_asset_group_id
606: from csi_item_instances cii
607: where cii.instance_id = p_maintenance_object_id;
608:
609: exception when no_data_found then
610: raise_error('EAM_NO_ITEM_FOUND');

Line 638: from csi_item_instances

634:
635: begin
636: select instance_id,3
637: into l_maintenance_object_id,l_maintenance_object_type
638: from csi_item_instances
639: where inventory_item_id=p_inventory_item_id
640: and serial_number=p_serial_number;
641:
642: exception

Line 653: from csi_item_instances

649:
650: begin
651: select inventory_item_id, serial_number, last_vld_organization_id
652: into l_asset_group_id , l_serial_number, l_temp_org_id
653: from csi_item_instances
654: where instance_id=p_maintenance_object_id;
655:
656: IF (l_org_id is null) THEN
657: l_org_id := l_temp_org_id;

Line 670: from csi_item_instances

666:
667: /* Check both the combinations are pointing to the same item / serial_number */
668:
669: select count(*) into l_count
670: from csi_item_instances
671: where instance_id=l_maintenance_object_id
672: and inventory_item_id=l_asset_group_id
673: and serial_number=l_serial_number;
674:

Line 1095: from mtl_system_items msi, csi_item_instances cii

1091:
1092: ELSE
1093: begin
1094: select msi.eam_item_type into l_item_type
1095: from mtl_system_items msi, csi_item_instances cii
1096: where cii.inventory_item_id = msi.inventory_item_id
1097: and cii.last_vld_organization_id = msi.organization_id
1098: and cii.instance_id = p_maintenance_object_id;
1099:

Line 1124: from csi_item_instances

1120: and p_maintenance_object_id IS NULL ) THEN
1121:
1122: begin
1123: select instance_id, 3 into l_maintenance_object_id, l_maintenance_object_type
1124: from csi_item_instances
1125: where serial_number = p_serial_number
1126: and inventory_item_id = p_inventory_item_id;
1127:
1128: exception when no_data_found then

Line 1139: from csi_item_instances cii

1135:
1136: begin
1137: select cii.serial_number, cii.inventory_item_id
1138: into l_serial_number, l_asset_group_id
1139: from csi_item_instances cii
1140: where cii.instance_id = p_maintenance_object_id;
1141:
1142: exception when no_data_found then
1143: raise_error('EAM_NO_ITEM_FOUND');

Line 1171: from csi_item_instances

1167:
1168: begin
1169: select instance_id,3
1170: into l_maintenance_object_id,l_maintenance_object_type
1171: from csi_item_instances
1172: where inventory_item_id=p_inventory_item_id
1173: and serial_number=p_serial_number;
1174:
1175: exception

Line 1186: from csi_item_instances

1182:
1183: begin
1184: select inventory_item_id, serial_number, last_vld_organization_id
1185: into l_item_id , l_serial_number, l_temp_org_id
1186: from csi_item_instances
1187: where instance_id=p_maintenance_object_id;
1188:
1189: IF (l_org_id is null) THEN
1190: l_org_id := l_temp_org_id;

Line 1203: from csi_item_instances

1199:
1200: /* Check both the combinations are pointing to the same item / serial_number */
1201:
1202: select count(*) into l_count
1203: from csi_item_instances
1204: where instance_id=l_maintenance_object_id
1205: and inventory_item_id=l_asset_group_id
1206: and serial_number=l_serial_number;
1207: