eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.EAM_ASSET_ROUTES_PUB dependencies on CSI_ITEM_INSTANCES

Line 422: from csi_item_instances

418: if (p_network_asset_number is not null and l_network_object_id IS NULL ) THEN
419:
420: begin
421: select instance_id into l_network_object_id
422: from csi_item_instances
423: where instance_number = p_network_asset_number;
424:
425: exception when no_data_found then
426: raise_error('EAM_NETWORK_REC_NOT_FOUND');

Line 436: from csi_item_instances

432: AND l_network_object_id IS NULL ) THEN
433:
434: begin
435: select instance_id into l_network_object_id
436: from csi_item_instances
437: where serial_number = l_network_serial_number
438: and inventory_item_id = l_network_item_id;
439: exception when no_data_found then
440: raise_error('EAM_NETWORK_REC_NOT_FOUND');

Line 450: from csi_item_instances cii

446:
447: begin
448: select cii.serial_number, cii.inventory_item_id
449: into l_network_serial_number, l_network_item_id
450: from csi_item_instances cii
451: where cii.instance_id = l_network_object_id;
452:
453: exception when no_data_found then
454: raise_error('EAM_NETWORK_REC_NOT_FOUND');

Line 463: from csi_item_instances cii

459:
460: --validate the network object Id exists
461: begin
462: select count(*) into l_count
463: from csi_item_instances cii
464: where cii.instance_id = l_network_object_id
465: and cii.serial_number = l_network_serial_number
466: and cii.inventory_item_id = l_network_item_id
467: and nvl(cii.network_asset_flag, 'N') = 'Y';

Line 519: from csi_item_instances

515: if (p_asset_number is not null and l_maintenance_object_id IS NULL ) THEN
516:
517: begin
518: select instance_id into l_maintenance_object_id
519: from csi_item_instances
520: where instance_number = p_asset_number;
521:
522: exception when no_data_found then
523: raise_error('EAM_NO_ITEM_FOUND');

Line 533: from csi_item_instances

529: AND l_maintenance_object_id IS NULL ) THEN
530:
531: begin
532: select instance_id into l_maintenance_object_id
533: from csi_item_instances
534: where serial_number = l_serial_number
535: and inventory_item_id = l_asset_group_id;
536:
537: exception when no_data_found then

Line 548: from csi_item_instances

544:
545: begin
546: select serial_number, inventory_item_id into
547: l_serial_number, l_asset_group_id
548: from csi_item_instances
549: where instance_id = l_maintenance_object_id;
550:
551: exception when no_data_found then
552: raise_error('EAM_NO_ITEM_FOUND');

Line 562: from csi_item_instances cii

558: /* Check both the combinations are pointing to the same item / serial_number */
559:
560: begin
561: select count(*) into l_count
562: from csi_item_instances cii
563: where cii.instance_id = l_maintenance_object_id
564: and cii.serial_number = l_serial_number
565: and cii.inventory_item_id = l_asset_group_id
566: and nvl(cii.network_asset_flag, 'N') = 'N';

Line 860: from csi_item_instances

856: if (p_network_asset_number is not null and l_network_object_id IS NULL ) THEN
857:
858: begin
859: select instance_id into l_network_object_id
860: from csi_item_instances
861: where instance_number = p_network_asset_number;
862:
863: exception when no_data_found then
864: raise_error('EAM_NETWORK_REC_NOT_FOUND');

Line 874: from csi_item_instances

870: AND l_network_object_id IS NULL ) THEN
871:
872: begin
873: select instance_id into l_network_object_id
874: from csi_item_instances
875: where serial_number = l_network_serial_number
876: and inventory_item_id = l_network_item_id;
877: exception when no_data_found then
878: raise_error('EAM_NETWORK_REC_NOT_FOUND');

Line 888: from csi_item_instances

884:
885: begin
886: select serial_number, inventory_item_id into
887: l_network_serial_number, l_network_item_id
888: from csi_item_instances
889: where instance_id = l_network_object_id;
890:
891: exception when no_data_found then
892: raise_error('EAM_NETWORK_REC_NOT_FOUND');

Line 902: from csi_item_instances cii

898:
899: --validate the network object Id exists
900: begin
901: select count(*) into l_count
902: from csi_item_instances cii
903: where cii.instance_id = l_network_object_id
904: and cii.serial_number = l_network_serial_number
905: and cii.inventory_item_id = l_network_item_id
906: and cii.network_asset_flag = 'Y';

Line 957: from csi_item_instances

953: if (p_asset_number is not null and l_maintenance_object_id IS NULL ) THEN
954:
955: begin
956: select instance_id into l_maintenance_object_id
957: from csi_item_instances
958: where instance_number = p_asset_number;
959:
960: exception when no_data_found then
961: raise_error('EAM_NO_ITEM_FOUND');

Line 971: from csi_item_instances

967: AND l_maintenance_object_id IS NULL ) THEN
968:
969: begin
970: select instance_id into l_maintenance_object_id
971: from csi_item_instances
972: where serial_number = l_serial_number
973: and inventory_item_id = l_asset_group_id;
974:
975: exception when no_data_found then

Line 986: from csi_item_instances

982:
983: begin
984: select serial_number, inventory_item_id into
985: l_serial_number, l_asset_group_id
986: from csi_item_instances
987: where instance_id = l_maintenance_object_id;
988:
989: exception when no_data_found then
990: raise_error('EAM_NO_ITEM_FOUND');

Line 1000: from csi_item_instances cii

996: /* Check both the combinations are pointing to the same item / serial_number */
997:
998: begin
999: select count(*) into l_count
1000: from csi_item_instances cii
1001: where cii.instance_id = l_maintenance_object_id
1002: and cii.serial_number = l_serial_number
1003: and cii.inventory_item_id = l_asset_group_id
1004: and cii.network_asset_flag = 'N';