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

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

Line 876: from csi_item_instances

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

Line 890: from csi_item_instances

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

Line 904: from csi_item_instances cii

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

Line 959: from csi_item_instances

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

Line 973: from csi_item_instances

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

Line 988: from csi_item_instances

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

Line 1002: from csi_item_instances cii

998: /* Check both the combinations are pointing to the same item / serial_number */
999:
1000: begin
1001: select count(*) into l_count
1002: from csi_item_instances cii
1003: where cii.instance_id = l_maintenance_object_id
1004: and cii.serial_number = l_serial_number
1005: and cii.inventory_item_id = l_asset_group_id
1006: and nvl(cii.network_asset_flag,'N') = 'N'; -- added nvl check for bug 15850452