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 1422: from mtl_serial_numbers msn, mtl_system_items msi

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

Line 2434: from mtl_serial_numbers

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

Line 2444: from mtl_serial_numbers

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

Line 2955: l_description mtl_serial_numbers.descriptive_text%TYPE;

2951: l_instance_id number;
2952: l_stmt_num number := 0;
2953: l_current_status number;
2954: l_organization_id number;
2955: l_description mtl_serial_numbers.descriptive_text%TYPE;
2956: l_eam_wo_rec EAM_PROCESS_WO_PUB.eam_wo_rec_type;
2957: begin
2958: -- Standard Start of API savepoint
2959: SAVEPOINT create_asset;

Line 2983: from mtl_serial_numbers msn

2979: --Figure out some unknowns
2980: BEGIN
2981: select msn.current_organization_id, msn.descriptive_text, msn.current_status
2982: into l_organization_id, l_description, l_current_status
2983: from mtl_serial_numbers msn
2984: where msn.inventory_item_id = nvl(l_eam_wo_rec.rebuild_item_id,
2985: l_eam_wo_rec.asset_group_id)
2986: and msn.serial_number = nvl(l_eam_wo_rec.rebuild_serial_number,
2987: l_eam_wo_rec.asset_number);

Line 3133: from mtl_serial_numbers msn, csi_item_instances cii

3129: -- Bug 6799616
3130: -- Added exception handling block in case the item instance is not serial
3131: begin
3132: select gen_object_id into l_gen_object_id
3133: from mtl_serial_numbers msn, csi_item_instances cii
3134: where msn.inventory_item_id = cii.inventory_item_id
3135: and msn.serial_number = cii.serial_number
3136: and cii.instance_id = p_maintenance_object_id;
3137: if (l_gen_object_id is not null) then

Line 3842: mtl_serial_numbers msn

3838: ELSIF l_maint_object_type = 3 THEN
3839:
3840: select count(1) into l_obj_exists
3841: from csi_item_instances cii,
3842: mtl_serial_numbers msn
3843: where cii.serial_number = msn.serial_number
3844: and cii.inventory_item_id = msn.inventory_item_id
3845: and cii.instance_id = l_maint_object_id
3846: and cii.last_vld_organization_id = l_org_id

Line 3890: from mtl_serial_numbers msn

3886: AND l_equipment_gen_object_id <> FND_API.G_MISS_NUM) then
3887: begin
3888: select msn.gen_object_id
3889: into l_gen_object_id
3890: from mtl_serial_numbers msn
3891: where msn.serial_number = p_serial_number
3892: and msn.inventory_item_id = p_inventory_item_id
3893: ;
3894:

Line 3907: update mtl_serial_numbers

3903:
3904: if (l_return_value = TRUE) then
3905:
3906: begin
3907: update mtl_serial_numbers
3908: set group_mark_id = 1
3909: where serial_number = p_serial_number
3910: and inventory_item_id = p_inventory_item_id;
3911: exception

Line 3918: update mtl_serial_numbers

3914: end;
3915: end if;
3916:
3917: begin
3918: update mtl_serial_numbers
3919: set eam_linear_location_id = -1
3920: where serial_number = p_serial_number
3921: and inventory_item_id = p_inventory_item_id;
3922: