APPS.EAM_ASSETATTR_VALUE_PUB dependencies on CSI_ITEM_INSTANCES

Line 115: FROM mtl_system_items MSI , csi_item_instances CII

111: IF (p_maintenance_object_type = 3) THEN
112: IF ( p_serial_number IS NOT NULL ) THEN
113:
114: SELECT count(*) INTO l_count_rec
115: FROM mtl_system_items MSI , csi_item_instances CII
116: WHERE cii.serial_number = p_serial_number
117: AND cii.instance_id = p_maintenance_object_id
118: AND CII.inventory_item_id = MSI.inventory_item_id
119: AND MSI.inventory_item_id = p_asset_group_id;

Line 175: from csi_item_instances

171:
172: if p_eam_item_type = 1
173: then
174: select count(*) into l_count
175: from csi_item_instances
176: where instance_id=p_object_id;
177: elsif p_eam_item_type = 2
178: then
179: select count(*) into l_count

Line 569: from mtl_system_items msi, csi_item_instances cii

565:
566: ELSE
567: begin
568: select msi.eam_item_type into l_item_type
569: from mtl_system_items msi, csi_item_instances cii
570: where cii.inventory_item_id = msi.inventory_item_id
571: and cii.last_vld_organization_id = msi.organization_id
572: and cii.instance_id = p_maintenance_object_id;
573:

Line 600: from csi_item_instances

596: and p_maintenance_object_id IS NULL ) THEN
597:
598: begin
599: select instance_id, 3 into l_maintenance_object_id, l_maintenance_object_type
600: from csi_item_instances
601: where serial_number = p_serial_number
602: and inventory_item_id = p_inventory_item_id;
603:
604: exception when no_data_found then

Line 615: from csi_item_instances cii

611:
612: begin
613: select cii.serial_number, cii.inventory_item_id
614: into l_serial_number, l_asset_group_id
615: from csi_item_instances cii
616: where cii.instance_id = p_maintenance_object_id;
617:
618: exception when no_data_found then
619: raise_error('EAM_NO_ITEM_FOUND');

Line 647: from csi_item_instances

643:
644: begin
645: select instance_id,3
646: into l_maintenance_object_id,l_maintenance_object_type
647: from csi_item_instances
648: where inventory_item_id=p_inventory_item_id
649: and serial_number=p_serial_number;
650:
651: exception

Line 662: from csi_item_instances

658:
659: begin
660: select inventory_item_id, serial_number, last_vld_organization_id
661: into l_asset_group_id , l_serial_number, l_temp_org_id
662: from csi_item_instances
663: where instance_id=p_maintenance_object_id;
664:
665: IF (l_org_id is null) THEN
666: l_org_id := l_temp_org_id;

Line 679: from csi_item_instances

675:
676: /* Check both the combinations are pointing to the same item / serial_number */
677:
678: select count(*) into l_count
679: from csi_item_instances
680: where instance_id=l_maintenance_object_id
681: and inventory_item_id=l_asset_group_id
682: and serial_number=l_serial_number;
683:

Line 1104: from mtl_system_items msi, csi_item_instances cii

1100:
1101: ELSE
1102: begin
1103: select msi.eam_item_type into l_item_type
1104: from mtl_system_items msi, csi_item_instances cii
1105: where cii.inventory_item_id = msi.inventory_item_id
1106: and cii.last_vld_organization_id = msi.organization_id
1107: and cii.instance_id = p_maintenance_object_id;
1108:

Line 1133: from csi_item_instances

1129: and p_maintenance_object_id IS NULL ) THEN
1130:
1131: begin
1132: select instance_id, 3 into l_maintenance_object_id, l_maintenance_object_type
1133: from csi_item_instances
1134: where serial_number = p_serial_number
1135: and inventory_item_id = p_inventory_item_id;
1136:
1137: exception when no_data_found then

Line 1148: from csi_item_instances cii

1144:
1145: begin
1146: select cii.serial_number, cii.inventory_item_id
1147: into l_serial_number, l_asset_group_id
1148: from csi_item_instances cii
1149: where cii.instance_id = p_maintenance_object_id;
1150:
1151: exception when no_data_found then
1152: raise_error('EAM_NO_ITEM_FOUND');

Line 1180: from csi_item_instances

1176:
1177: begin
1178: select instance_id,3
1179: into l_maintenance_object_id,l_maintenance_object_type
1180: from csi_item_instances
1181: where inventory_item_id=p_inventory_item_id
1182: and serial_number=p_serial_number;
1183:
1184: exception

Line 1195: from csi_item_instances

1191:
1192: begin
1193: select inventory_item_id, serial_number, last_vld_organization_id
1194: into l_item_id , l_serial_number, l_temp_org_id
1195: from csi_item_instances
1196: where instance_id=p_maintenance_object_id;
1197:
1198: IF (l_org_id is null) THEN
1199: l_org_id := l_temp_org_id;

Line 1212: from csi_item_instances

1208:
1209: /* Check both the combinations are pointing to the same item / serial_number */
1210:
1211: select count(*) into l_count
1212: from csi_item_instances
1213: where instance_id=l_maintenance_object_id
1214: and inventory_item_id=l_asset_group_id
1215: and serial_number=l_serial_number;
1216: