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_COMMON_UTILITIES_PVT dependencies on MTL_SERIAL_NUMBERS

Line 644: FROM MTL_SERIAL_NUMBERS

640: l_stmt_num := 100;
641:
642: SELECT count(*)
643: INTO l_count
644: FROM MTL_SERIAL_NUMBERS
645: WHERE serial_number = l_concat_asset_number
646: and inventory_item_id=p_inventory_item_id;
647:
648: /* Fix for bug 3408752. Case 2

Line 677: FROM MTL_SERIAL_NUMBERS

673: ELSIF (l_serial_number_type = 2) THEN
674: l_stmt_num := 110;
675: SELECT count(*)
676: INTO l_count
677: FROM MTL_SERIAL_NUMBERS
678: WHERE SERIAL_NUMBER = l_concat_asset_number
679: AND CURRENT_ORGANIZATION_ID = p_organization_id;
680:
681: IF (l_count > 0) THEN

Line 688: FROM MTL_SERIAL_NUMBERS S,

684:
685: l_stmt_num := 120;
686: SELECT count(*)
687: INTO l_count
688: FROM MTL_SERIAL_NUMBERS S,
689: MTL_PARAMETERS P
690: WHERE S.CURRENT_ORGANIZATION_ID = P.ORGANIZATION_ID
691: AND S.SERIAL_NUMBER = l_concat_asset_number
692: AND P.SERIAL_NUMBER_TYPE = 3;

Line 728: FROM MTL_SERIAL_NUMBERS

724: ELSIF (l_serial_number_type = 3 ) THEN
725: l_stmt_num := 130;
726: SELECT count(*)
727: INTO l_count
728: FROM MTL_SERIAL_NUMBERS
729: WHERE SERIAL_NUMBER = l_concat_asset_number;
730:
731: IF (l_count > 0 ) THEN
732: l_success := FND_API.G_FALSE;

Line 778: from mtl_serial_numbers msn1, mtl_system_items msi1

774:
775: if (l_base_item_id is not null) then
776: if (l_concat_asset_number is not null) then
777: select count(*) into l_count
778: from mtl_serial_numbers msn1, mtl_system_items msi1
779: where msn1.serial_number = l_concat_asset_number
780: and msn1.inventory_item_id = msi1.inventory_item_id
781: and msn1.current_organization_id = msi1.organization_id
782: and msi1.base_item_id = l_base_item_id;

Line 792: FROM MTL_SERIAL_NUMBERS

788: --Bug 5188972
789: else
790: SELECT count(*)
791: INTO l_count
792: FROM MTL_SERIAL_NUMBERS
793: WHERE serial_number = l_concat_asset_number
794: AND inventory_item_id=p_inventory_item_id;
795: IF (l_count > 0) THEN
796: l_success := FND_API.G_FALSE;

Line 1421: from mtl_serial_numbers msn, mtl_system_items msi

1417: select msn.current_organization_id,
1418: msn.inventory_item_id,
1419: msn.serial_number
1420: into l_organization_id, l_inventory_item_id, l_serial_number
1421: from mtl_serial_numbers msn, mtl_system_items msi
1422: where
1423: msn.gen_object_id=p_maintenance_object_id and
1424: msi.inventory_item_id=msn.inventory_item_id and
1425: msi.organization_id=msn.current_organization_id and

Line 2433: from mtl_serial_numbers

2429: where serial_number = p_serial_number
2430: and inventory_item_id = p_inventory_item_id
2431: ;
2432: select gen_object_id into l_gen_object_id
2433: from mtl_serial_numbers
2434: where serial_number = p_serial_number
2435: and inventory_item_id = p_inventory_item_id
2436: ;
2437: else

Line 2443: from mtl_serial_numbers

2439: l_gen_object_id := p_gen_object_id;
2440:
2441: select serial_number, inventory_item_id, current_organization_id
2442: into l_serial_number, l_inventory_item_id, l_organization_id
2443: from mtl_serial_numbers
2444: where gen_object_id = p_gen_object_id;
2445:
2446: end if;
2447:

Line 2836: l_description mtl_serial_numbers.descriptive_text%TYPE;

2832: l_instance_id number;
2833: l_stmt_num number := 0;
2834: l_current_status number;
2835: l_organization_id number;
2836: l_description mtl_serial_numbers.descriptive_text%TYPE;
2837: l_eam_wo_rec EAM_PROCESS_WO_PUB.eam_wo_rec_type;
2838: begin
2839: -- Standard Start of API savepoint
2840: SAVEPOINT create_asset;

Line 2864: from mtl_serial_numbers msn

2860: --Figure out some unknowns
2861: BEGIN
2862: select msn.current_organization_id, msn.descriptive_text, msn.current_status
2863: into l_organization_id, l_description, l_current_status
2864: from mtl_serial_numbers msn
2865: where msn.inventory_item_id = nvl(l_eam_wo_rec.rebuild_item_id,
2866: l_eam_wo_rec.asset_group_id)
2867: and msn.serial_number = nvl(l_eam_wo_rec.rebuild_serial_number,
2868: l_eam_wo_rec.asset_number);

Line 3013: from mtl_serial_numbers msn, csi_item_instances cii

3009: -- Bug 6799616
3010: -- Added exception handling block in case the item instance is not serial
3011: begin
3012: select gen_object_id into l_gen_object_id
3013: from mtl_serial_numbers msn, csi_item_instances cii
3014: where msn.inventory_item_id = cii.inventory_item_id
3015: and msn.serial_number = cii.serial_number
3016: and cii.instance_id = p_maintenance_object_id;
3017: if (l_gen_object_id is not null) then

Line 3698: mtl_serial_numbers msn

3694: ELSIF l_maint_object_type = 3 THEN
3695:
3696: select count(1) into l_obj_exists
3697: from csi_item_instances cii,
3698: mtl_serial_numbers msn
3699: where cii.serial_number = msn.serial_number
3700: and cii.inventory_item_id = msn.inventory_item_id
3701: and cii.instance_id = l_maint_object_id
3702: and cii.last_vld_organization_id = l_org_id

Line 3746: from mtl_serial_numbers msn

3742: AND l_equipment_gen_object_id <> FND_API.G_MISS_NUM) then
3743: begin
3744: select msn.gen_object_id
3745: into l_gen_object_id
3746: from mtl_serial_numbers msn
3747: where msn.serial_number = p_serial_number
3748: and msn.inventory_item_id = p_inventory_item_id
3749: ;
3750:

Line 3763: update mtl_serial_numbers

3759:
3760: if (l_return_value = TRUE) then
3761:
3762: begin
3763: update mtl_serial_numbers
3764: set group_mark_id = 1
3765: where serial_number = p_serial_number
3766: and inventory_item_id = p_inventory_item_id;
3767: exception

Line 3774: update mtl_serial_numbers

3770: end;
3771: end if;
3772:
3773: begin
3774: update mtl_serial_numbers
3775: set eam_linear_location_id = -1
3776: where serial_number = p_serial_number
3777: and inventory_item_id = p_inventory_item_id;
3778: