APPS.WMS_TASK_UTILS_PVT dependencies on MTL_SYSTEM_ITEMS

Line 340: FROM mtl_system_items msi, mtl_material_transactions_temp mmtt

336: SELECT msi.lot_control_code
337: , msi.serial_number_control_code
338: INTO v_lot_control_code
339: , v_serial_control_code
340: FROM mtl_system_items msi, mtl_material_transactions_temp mmtt
341: WHERE msi.inventory_item_id = mmtt.inventory_item_id
342: AND msi.organization_id = mmtt.organization_id
343: AND mmtt.transaction_temp_id = p_temp_id;
344:

Line 938: FROM mtl_system_items msi

934: l_org_id := mmt_row.organization_id;
935:
936: --Bug#5010991. Get the PRIMARY_UOM_CODE for the item.
937: SELECT msi.primary_uom_code INTO l_item_uom_code
938: FROM mtl_system_items msi
939: WHERE msi.inventory_item_id=l_item_id
940: AND msi.organization_id=l_org_id;
941:
942:

Line 1177: FROM mtl_system_items

1173: SELECT lot_control_code
1174: , serial_number_control_code
1175: INTO v_lot_control_code
1176: , v_serial_control_code
1177: FROM mtl_system_items
1178: WHERE inventory_item_id = l_item_id
1179: AND organization_id = l_org_id;
1180:
1181: IF (l_debug = 1) THEN

Line 1678: FROM mtl_system_items

1674: INTO v_rev_control_code
1675: , v_lot_control_code
1676: , v_serial_control_code
1677: , l_uom
1678: FROM mtl_system_items
1679: WHERE inventory_item_id = mmtt_table(cnt).inventory_item_id
1680: AND organization_id = mmtt_table(cnt).organization_id;
1681: EXCEPTION
1682: WHEN OTHERS THEN