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_SYSTEM_ITEMS

Line 229: FROM mtl_system_items_kfv msikfv, mtl_parameters mp

225: l_stmt_num := 70;
226:
227: SELECT msikfv.inventory_item_id
228: INTO l_inventory_item_id
229: FROM mtl_system_items_kfv msikfv, mtl_parameters mp
230: WHERE msikfv.organization_id = mp.organization_id
231: AND mp.maint_organization_id = l_organization_id
232: AND msikfv.concatenated_segments = l_concatenated_segments
233: AND rownum = 1;

Line 594: | Get the serial prefix and the start number from MTL_SYSTEM_ITEMS.

590:
591: ELSIF (l_serial_generation = 2) THEN
592: /*----------------------------------------------------------------+
593: | Serial number generation is set to the item level.
594: | Get the serial prefix and the start number from MTL_SYSTEM_ITEMS.
595: +--------------------------------------------------------------*/
596:
597: l_stmt_num := 80;
598: SELECT AUTO_SERIAL_ALPHA_PREFIX,

Line 602: FROM MTL_SYSTEM_ITEMS

598: SELECT AUTO_SERIAL_ALPHA_PREFIX,
599: START_AUTO_SERIAL_NUMBER
600: INTO l_asset_prefix,
601: l_asset_number
602: FROM MTL_SYSTEM_ITEMS
603: WHERE INVENTORY_ITEM_ID = p_inventory_item_id
604: AND ORGANIZATION_ID = p_organization_id;
605: -- FOR UPDATE OF START_AUTO_SERIAL_NUMBER;
606:

Line 658: MTL_SYSTEM_ITEMS msi, MTL_PARAMETERS mp

654: Check for item start_serial_number in all orgs for that item */
655: ELSE
656: select count(*) into l_count
657: from
658: MTL_SYSTEM_ITEMS msi, MTL_PARAMETERS mp
659: where
660: msi.organization_id=mp.organization_id and
661: mp.serial_number_generation = 2 and
662: msi.inventory_item_id=p_inventory_item_id and

Line 740: MTL_SYSTEM_ITEMS msi, MTL_PARAMETERS mp

736: /* Fix Case 5*/
737: /* check in orgs with item level serial number generation */
738: select count(*) into l_count
739: from
740: MTL_SYSTEM_ITEMS msi, MTL_PARAMETERS mp
741: where
742: msi.organization_id=mp.organization_id and
743: mp.serial_number_generation = 2 and
744: msi.inventory_item_id=p_inventory_item_id and

Line 771: from mtl_system_items

767: -- bug 3718290: serial_number_type = 1 means uniqueness 'within inventory model and items'
768: ELSIF (l_serial_number_type = 1 ) THEN
769: select base_item_id
770: into l_base_item_id
771: from mtl_system_items
772: where inventory_item_id = p_inventory_item_id
773: and organization_id = p_organization_id;
774:
775: if (l_base_item_id is not null) then

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 800: MTL_SYSTEM_ITEMS msi, MTL_PARAMETERS mp

796: l_success := FND_API.G_FALSE;
797: ELSE
798: SELECT count(*) INTO l_count
799: FROM
800: MTL_SYSTEM_ITEMS msi, MTL_PARAMETERS mp
801: WHERE
802: msi.organization_id=mp.organization_id AND
803: mp.serial_number_generation = 2 AND
804: msi.inventory_item_id=p_inventory_item_id AND

Line 852: | Get the serial prefix and the start number from MTL_SYSTEM_ITEMS.

848:
849: ELSIF (l_serial_generation = 2) THEN
850: /*----------------------------------------------------------------+
851: | Serial number generation is set to the item level.
852: | Get the serial prefix and the start number from MTL_SYSTEM_ITEMS.
853: +--------------------------------------------------------------*/
854: l_stmt_num := 150;
855: UPDATE MTL_SYSTEM_ITEMS
856: SET AUTO_SERIAL_ALPHA_PREFIX = l_asset_prefix,

Line 855: UPDATE MTL_SYSTEM_ITEMS

851: | Serial number generation is set to the item level.
852: | Get the serial prefix and the start number from MTL_SYSTEM_ITEMS.
853: +--------------------------------------------------------------*/
854: l_stmt_num := 150;
855: UPDATE MTL_SYSTEM_ITEMS
856: SET AUTO_SERIAL_ALPHA_PREFIX = l_asset_prefix,
857: START_AUTO_SERIAL_NUMBER = l_asset_number
858: WHERE INVENTORY_ITEM_ID = p_inventory_item_id
859: AND ORGANIZATION_ID = p_organization_id;

Line 1058: from mtl_system_items_kfv msi

1054:
1055: if l_inventory_item_id is not null then
1056: select concatenated_segments
1057: into l_item_name
1058: from mtl_system_items_kfv msi
1059: where organization_id = l_organization_id
1060: and inventory_item_id = l_inventory_item_id;
1061: end if;
1062:

Line 1083: from mtl_system_items

1079: ) return boolean is
1080: l_count number;
1081: begin
1082: select count(*) into l_count
1083: from mtl_system_items
1084: where inventory_item_id=p_inventory_item_id
1085: and organization_id=p_organization_id
1086: and eam_item_type=p_eam_item_type;
1087:

Line 1109: from csi_item_instances cii, mtl_system_items msi, mtl_parameters mp

1105: ) return boolean is
1106: l_count number;
1107: begin
1108: select count(*) into l_count
1109: from csi_item_instances cii, mtl_system_items msi, mtl_parameters mp
1110: where cii.last_vld_organization_id=mp.organization_id
1111: and msi.organization_id = cii.last_vld_organization_id
1112: and mp.maint_organization_id = p_organization_id
1113: and cii.inventory_item_id=p_inventory_item_id

Line 1362: from csi_item_instances cii, mtl_system_items msi, mtl_parameters mp

1358: from EAM UIs, I'm not specifically testing for the type of work order
1359: this row may represent */
1360:
1361: select count(*) into l_count
1362: from csi_item_instances cii, mtl_system_items msi, mtl_parameters mp
1363: where
1364: msi.organization_id=cii.last_vld_organization_id and
1365: msi.inventory_item_id=cii.inventory_item_id and
1366: cii.instance_id = p_maintenance_object_id and

Line 1381: from mtl_system_items msi, mtl_parameters mp

1377: return false;
1378: end if;
1379:
1380: select count(*) into l_count
1381: from mtl_system_items msi, mtl_parameters mp
1382: where
1383: msi.inventory_item_id=p_maintenance_object_id
1384: and msi.eam_item_type=p_eam_item_type
1385: and msi.organization_id=mp.organization_id

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 1439: from mtl_system_items

1435: elsif (p_maintenance_object_type=2) then
1436: select organization_id,
1437: inventory_item_id
1438: into l_organization_id, l_inventory_item_id
1439: from mtl_system_items
1440: where
1441: organization_id=p_organization_id and
1442: inventory_item_id=p_maintenance_object_id
1443: and eam_item_type=p_eam_item_type;

Line 1485: from mtl_system_items

1481: x_maintenance_object_type:=3;
1482: else
1483: select inventory_item_id
1484: into x_maintenance_object_id
1485: from mtl_system_items
1486: where inventory_item_id=p_inventory_item_id
1487: and eam_item_type in (1,3)
1488: and rownum = 1;
1489:

Line 1522: from mtl_system_items

1518: AND cii.last_vld_organization_id = mp.organization_id;
1519: elsif (p_maintenance_object_type=2) then
1520: select inventory_item_id
1521: into x_inventory_item_id
1522: from mtl_system_items
1523: where inventory_item_id=p_maintenance_object_id
1524: and eam_item_type in (1,3)
1525: and rownum = 1;
1526: x_serial_number:=null;

Line 2669: FROM mtl_system_items_b msi

2665: SELECT
2666: msi.lot_control_code,
2667: msi.serial_number_control_code,
2668: msi.revision_qty_control_code
2669: FROM mtl_system_items_b msi
2670: WHERE msi.organization_id = c_organization_id
2671: AND msi.inventory_item_id = c_inventory_item_id;
2672:
2673: l_is_revision_control BOOLEAN;

Line 2756: MTL_SYSTEM_ITEMS MSI

2752: SELECT NVL(SUM(QUANTITY),0)
2753: into l_qoh
2754: FROM MTL_SECONDARY_INVENTORIES MSS,
2755: MTL_ITEM_QUANTITIES_VIEW MOQ,
2756: MTL_SYSTEM_ITEMS MSI
2757: WHERE MOQ.ORGANIZATION_ID = p_org_id
2758: AND MSI.ORGANIZATION_ID = p_org_id
2759: AND MSS.ORGANIZATION_ID = p_org_id
2760: AND MOQ.INVENTORY_ITEM_ID = p_inventory_item_id

Line 3686: from mtl_system_items_b_kfv msik

3682: return l_return_status;
3683: ELSIF l_maint_object_type = 2 THEN
3684:
3685: select count(1) into l_obj_exists
3686: from mtl_system_items_b_kfv msik
3687: where msik.inventory_item_id = l_maint_object_id
3688: AND msik.organization_id = l_org_id;
3689:
3690: IF l_obj_exists = 1 THEN