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 1059: from mtl_system_items_kfv msi

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

Line 1084: from mtl_system_items

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

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

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

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

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

Line 1382: from mtl_system_items msi, mtl_parameters mp

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

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

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

Line 1486: from mtl_system_items

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

Line 1523: from mtl_system_items

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

Line 2670: FROM mtl_system_items_b msi

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

Line 2757: MTL_SYSTEM_ITEMS MSI

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

Line 2780: FROM mtl_system_items_b_kfv mtlbkfv

2776: SELECT
2777: mtlbkfv.lot_control_code,
2778: mtlbkfv.serial_number_control_code,
2779: mtlbkfv.revision_qty_control_code
2780: FROM mtl_system_items_b_kfv mtlbkfv
2781: WHERE mtlbkfv.organization_id = c_organization_id
2782: AND mtlbkfv.inventory_item_id = c_inventory_item_id;
2783:
2784: l_is_revision_control BOOLEAN;

Line 3155: mtl_system_items_b msib,

3151: serial_number_control_code
3152: into
3153: l_serial_number_control_code
3154: FROM
3155: mtl_system_items_b msib,
3156: csi_item_instances cii
3157: WHERE
3158: cii.inventory_item_id=msib.inventory_item_id
3159: AND cii.last_vld_organization_id=msib.organization_id

Line 3830: from mtl_system_items_b_kfv msik

3826: return l_return_status;
3827: ELSIF l_maint_object_type = 2 THEN
3828:
3829: select count(1) into l_obj_exists
3830: from mtl_system_items_b_kfv msik
3831: where msik.inventory_item_id = l_maint_object_id
3832: AND msik.organization_id = l_org_id;
3833:
3834: IF l_obj_exists = 1 THEN